This function evaluates a formula and returns a value you provide if there is an error or the formula result.
Syntax
IFERROR(value,error)
Arguments
This function has these arguments:
| Argument | Description |
|---|---|
| value | Value or expression to evaluate |
| error | Value to return if the formula returns an error |
Remarks
The following error types are evaluated, #VALUE!, #REF!, #NUM!, #NAME?, #DIV/O, #N/A, or #NULL
Data Types
Accepts any type of formula for the value. Returns any data type.
Example
IFERROR(A3/A5,"dogs")
Version Available
This function is available in product version 5.0 or later.
See Also
AND | FALSE | Logical Functions