<< Click to Display Table of Contents >> IFNA (return defined value for #N/A) |
Syntax:
IFNA(Cell, Value)
Description:
Normally returns the content of the Cell. However, if this cell is #N/A, the defined Value is returned instead.
Compatibility notes:
Microsoft Excel supports this function only in version 2013 or later. In older versions, the function is unknown.
Example:
IFNA(A1, "not found!") returns the value in cell A1, as long as A1 doesn't contain the error value #N/A. If it does contain the error value #N/A, the text string "not found!" is returned instead.
See also:
IFERROR, ISERR, ISERROR, ISNA, ERROR.TYPE, section Error values