Returns the specified value unless it is the #N/A error value, in which case returns the specified alternative value.
Syntax
 Copy Code
|
|---|
IFNA( Any value, Any alternative ) → Any |
Parameters
- value
- Required. The argument to check for the #N/A error value.
- alternative
- Required. The value to return if value is #N/A.
Example
| Formula
Copy Code
|
|---|
=IFNA(VLOOKUP("Apples",A1:B10,5),"Not found") |
See Also
Function Reference
IF Function
ISNA Function