Error handler in Excel #IFERROR

Here is a new post to which will help you to handle the error in excel.

IFERROR this function is used to check and handle errors in a formula. It will evaluate the error in the formula, which is specified in given cell value; otherwise, returns the result of the formula.

Syntax =IFERROR (value, value_if_error)

value - The value, reference, or formula to check for an error.
value_if_error - The value to return if an error is found.

Example for IFERROR



Table 1: Column C indicates the output of the regular ratio formula. Refer syntax in column D

Table 2: Column C indicates the output of the ratio using the IFERROR function. Refer syntax in column D

You can observe we are getting #DIV  in Table 1 because of 55/0 in a mathematical error.
However in Table 2 on using IFERROR function we see the output is as NO Sales.

Notes:

• If the value is empty, it is evaluated as an empty string ("") and not an error.


• If value_if_erroris supplied as an empty string (""), no message is displayed when an error is detected.


• If IFERROR is entered as an array formula, it returns an array of results with one item for each cell in value.