ISNA

Definition: ISNA is a function that returns TRUE if a value is #N/A, and FALSE if it is any other value.

Syntax: =ISNA(value)

Situation: This formula is appropriate when you need to check if a value is #N/A.

Example: If you want to check if cell A1 contains #N/A, the formula =ISNA(A1) will return TRUE if it contains #N/A.