How to Use IFERROR Function

The IFERROR function returns the value you specified when a formula evaluates to an error, otherwise, the function returns the results of the formula.

Formula:

= IFERROR(value, value_if_error)

Explanation:

- Value is required, the argument to check whether it is an error.

- Value_if_error is required, the value to return when the formula evaluates to an error.

Example 1: To checks the results for the formula A2/B2. The result returns the results of the formula, which is 2 (=100/50).

Example 2: To check the results for the formula A3/B3. The result returns an error because 0 can not be a denominator. The function returns the specified value which is "ERROR".

Download: IFERROR Function

Leave a Reply