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