| Syntax |
| =IFERROR(value,value_if_error) |
| Purpose / Description |
| Traps any error value if returned from a nested formula or reference and returns an alternative value instead. |
| Arguments |
| Name |
Type |
Description |
| value |
any |
A constant, reference or nested expression that returns the value to be checked and replaced if it is an error value (any of the presently 14 errors). |
| value_if_error |
any |
A constant, reference or nested expression that provides the alternative value to be returned by the function if value is an error value. |
| Return Values |
| Type |
Specific Value |
Description |
| any |
|
Original value of value argument, unless it is an error, in which case the value of the value_if_error argument is returned. |
| Notes / Comments / Advice / Warnings |
| Note: |
Any errors referenced by arguments will be handled, so no propagation of errors occurs with this function. |
| Comment: |
The advent of the IFERROR function means that error handling has been simplified. |
| Advice: |
We strongly recommend against the use of the IFERROR function to handle unmatched values in lookups and matches. The IFNA function is always to be preferred. In general we make little use of IFERROR, since there are often better ways of managing the errors, but we reserve it for use with the GETPIVOTDATA function, as there are no other more practical solutions. |
| |