ISNA


Description Determines if the specified expression returns the value not available error.

Syntax ISNA ( expression )

Argument Description
expression Any expression.

Remarks If expression returns the #N/A! error, True is returned. Otherwise, False is returned.

Example This function returns True if cell A1 contains the NA ( ) function or returns the error value #N/A!:

ISNA(A1)

See Also ISBLANK, ISERR, ISERROR, ISLOGICAL, ISNONTEXT, ISNUMBER, ISREF, ISTEXT