Explainry Tutorials to Expert in IT

IFERROR function in Excel


IFERROR function (a logical function) returns a specified value if an error found; otherwise, returns the result of the formula. It is a useful function to handle errors in Excel.


=IFERROR(value, value_if_error)

The function has the following arguments:

value – Required. The value that will be checked for an error.

value_if_error – Required. The value to return if error is found. The function checks for following errors: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!.


When a number is divided by 0, Excel returns the DIV/0! error.

To handle the DIV/0! error, the IFERROR function will first check for the error, if found then display the message “Error in calculation”.


For more examples, visit Microsoft Office website.

Copyright © 2016 - 2020 Explainry.com | All Rights Reserved