Summary
The 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.
Purpose
Return custom value when formula return an ERROR
Syntax
= IFERROR ( value, value_if_error )
Arguments
value: Formula to check for error
value_if_error: The value to return if an error is found
Example Explanation
In 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 2
You can also use IFERROR function with VLOOKUP to catch #N/A error. Formula can be use as:
