IFERROR

Checks if the expression has an error and, returns a replacement value, if so, or the original value otherwise.

Syntax

=IFERROR(expression, replacement)

Arguments

Argument	Type	Description
expression	Any	The expression to evaluate for errors
replacement	Any	The value to return if the expression evaluation resulted in an error

Examples

=IFERROR(1 + [1, 2, 3], 0) → 0
Because an error occured during evaluation the value 0 was returned.

=IFERROR(1 + 2, 0) → 3
Because no error occured during evaluation the resulting value was returned.