Functions
ISNA
True if value is #N/A
Try it
When to use it
When should I use ISNA?
Use ISNA to test specifically for the #N/A error — which signals a missing or unavailable value — so you can handle lookup misses or missing data differently from other error types.
Used in
Syntax
ISNA(value)