IFERROR

Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula.

Syntax

IFERROR(value, value_if_error)

Arguments

• value: The argument that is checked for an error.
• value_if_error: The value to return if the formula evaluates to an error.

Example

IFERROR(A1/B1, 0) → Returns the result of A1/B1 if it's not an error, otherwise returns 0.