ISNA

Description

ISNA determines if the specified expression returns the "value not available" error.

Syntax

ISNA ( expression )

Remarks

If the 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)

Also, see

ISBLANK

ISERR

ISERROR

ISLOGICAL

ISNONTEXT

ISNUMBER

ISREF

ISTEXT