Free Online Tutorials on Spreadsheets

IFERROR function in Excel

Use

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.

Syntax

=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!.

Example

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”.

Result.

For more examples, visit Microsoft Office website.




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