IFERROR
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)
Parameters
- 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
Example
=IFERROR(A1/B1, "Error in calculation")