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.