ISNA

Checks whether the specified value is the #N/A error value.

Syntax

ISNA( Any x ) → Logical

Parameters

x

Required. The value to test.

Remarks

If x is the #N/A error value, returns TRUE; if x is any of the other error values, or not an error value, returns FALSE. Note that this function does not propagate error values.

Example

Formula

=ISNA(NA())

See Also

Function Reference
ERROR.TYPE Function
ISBLANK Function
ISERR Function
ISERROR Function
ISLOGICAL Function
ISNONTEXT Function
ISREF Function
TYPE Function