Rows has joined Superhuman. Learn more. The Superhuman Privacy Policy and Terms will apply as of June 16.

IFERROR

Get an alternative value in case of 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"