ISNA

Checks if a given value or reference is an Error of type #N/A

Parameter List

Syntax
ISNA(value)
value

The value to be compared with the error value #N/A.

More details

ISNA() returns TRUE if value is #N/A or a reference to a cell containing #N/A and false otherwise.

Examples

ISNA(#N/A) returns TRUE
🍪

We use cookies to enhance your user experience and analyze website performance. You can revoke consent anytime. Learn more.