IFERROR

Returns the specified value unless it is an error, in which case returns the specified alternative value.

Syntax

IFERROR( Any value, Any alternative ) → Any

Parameters

value

Required. The argument to check for an error.

alternative

Required. The value to return if value is an error.

Remarks

This function is useful to trap and handle formula errors.

Example

Formula

=IFERROR(1/0,"Division by zero")

See Also

Function Reference
IF Function
ISERROR Function