IFERROR

Return an alternative value if the first argument returns an error.

Parameter List

Syntax
IFERROR(expression
[error_value]
)
expression

A value or cell reference to be evaluated. For example: 1/0.

[optional] error_value

The value to display if expression returns an error. For example: "Cell contains an error".

Examples

IFERROR(1/0, "Woops, that's an error") returns "Woops, that's an error"