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

Syntax  Copy Code
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  Copy Code
=IFERROR(1/0,"Division by zero")

See Also

Function Reference
IF Function
ISERROR Function