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