IFERROR function
Summary
Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula
Syntax
IFERROR(value, value_if_error)
The IFERROR function syntax has the following arguments:
• value Required. The argument that is checked for an error.
• value_if_error Required. The value to return if the formula evaluates to an error. The following error types are evaluated: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!.
• value Required. The argument that is checked for an error.
• value_if_error Required. The value to return if the formula evaluates to an error. The following error types are evaluated: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!.
Example
=IFERROR(A2/B2, "Error in calculation")
=IFERROR(A3/B3, "Error in calculation")
=IFERROR(A4/B4, "Error in calculation")
=C2
=C3
=C4
=IFERROR(A3/B3, "Error in calculation")
=IFERROR(A4/B4, "Error in calculation")
=C2
=C3
=C4