IFERROR function

description:

Returns value_if_error if an expression is an error and the value of the expression itself otherwise.

 

syntax:

=IFERROR( value, value_if_error)

 

required arguments:

value The value, reference, or formula to check for an error.
value_if_error The value to return if an error is found.