### ⬇️ Pop in your Name & Email to get the file!

What do you think will be the result for the following

• 4 divided by 2
• 90 divided by 9
• 44 divided by 0

If your division formula went oops (#DIV/0!) on the 3rd one then for handling situations like these you can use IFERROR Function in Excel. The error could be anything but IFERROR steps in with an alternative, in-case your formula returns an error

## Here is how it works!

In the example below \$30,000/3 will work fine but \$40,000/0 will give an error because you can’t divide a number in excel by 0 (zero). Therefore a DIV error!

To cosmetically improve the result wrap the division in the IFERROR function.

IFERROR accepts two inputs

1. Value – This could be a number, text or even a formula (in our case this is the division formula)
2. Value if Error – What do you want in case the first part results in an error. Again this could a number, text or another formula too. In our case whenever there is a divide by zero then the output will be “Not Possible”.

Alternatively, we could have also placed a 0 (zero for the second part) of the IFERROR function

Related Articles : IF, NESTEDIF, AND & BOOLEAN Logic