| Syntax |
| =IFNA(value,value_if_na) |
| Purpose / Description |
| Traps the #N/A 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 the value #N/A. |
| value_if_na |
any |
A constant, reference or nested expression that provides the alternative value to be returned by the function if value is #N/A. |
| Return Values |
| Type |
Specific Value |
Description |
| any |
|
Original value of value argument, unless it is #N/A, in which case the value of the value_if_na argument is returned. |
| error |
|
Any errors referenced by arguments are returned due to propagation of error values. |
| Notes / Comments / Advice / Warnings |
| Comment: |
The advent of the IFNA function means that error handling for lookups and matches can be streamlined. |
| 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. |
| |