Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula.
Category: Logical
Parameters
value: any
The argument that is checked for an error.
value_if_error: any
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!.
Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula.
Category: Logical