ISNA

See also A-Z Spreadsheet Function List

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

Syntax ISNA(expression)

expression is any expression.

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

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

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