<< Click to Display Table of Contents >> IFNA (return defined value for #N/A)

Syntax:

IFNA(Cell, Value)

Description:

This normally returns the content of the Cell. If this cell is #N/A, however, the defined Value is returned instead.

Compatibility notes:

Microsoft Excel supports this function only in version 2013 or later. The function is unknown in older versions.

Example:

IFNA(A1, "not found!") returns the value in cell A1 as long as it doesn't contain the #N/A error value. If it does contain the #N/A error value, however, the text string "not found!" is returned instead.

See also:

IFERROR, ISERR, ISERROR, ISNA, ERROR.TYPE, section Error values