IFERROR

Returns result if an expression does not return an error and another if it ends with Error.

Syntax

IFERROR(expression, valueIfError)

• expression - An expression to be evaluated.

• valueIfError - The value the function returns if expression evaluates to an error. The following error types are evaluated: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, #NULL!

Sample Usage

Return Value

• Returns value.

Notes

See Also