DOWNLOAD THE EXCEL FILE USED IN THE VIDEO

 

What do you think will be the result for the following

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

IFERROR Function in Excel

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!

IFERROR function in excel 1
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”.

IFERROR function in excel 2

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

Related Articles : IF, NESTEDIF, AND & BOOLEAN Logic

If you have any questions please put them down in comments, I’ll be glad to help

 



Topics that I write about...






Download Smart Ebooks on
Excel and Power BI