IFNA (return defined value for #N/A)

<< 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