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.
Updated 8 months ago