SummaryThe Excel IFERROR function return custom value when formula returns an error. IFERROR is an elegant way to manage errors without using more complicated nested IF statements.
PurposeReturn custom value when formula return an ERROR
Syntax= IFERROR ( value, value_if_error )
Argumentsvalue: Formula to check for error
value_if_error: The value to return if an error is found
Example ExplanationIn above mentioned example, we have simply divided value 1 / Value 2. In cell E7, Value 1 is having 0. Ideally it should show as error but since we have used IFERROR formula, hence it is showing as final result as 0%. Formula used in E7 is:
Example 2You can also use IFERROR function with VLOOKUP to catch #N/A error. Formula can be use as: