ISNA

InformationExcel 2007

TRUE only for the #N/A error.

Syntax

ISNA(value)

Examples

=IF(ISNA(MATCH(A2, list, 0)), "new", "known")

→

Related functions

IFNA ISERROR NA

More Information functions

CELL ERROR.TYPE INFO ISBLANK ISERR ISERROR ISEVEN ISFORMULA ISLOGICAL ISNONTEXT ISNUMBER ISODD

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.