Checks whether a value is the #N/A error and returns TRUE or FALSE.
This function works the same in Google Sheets as it does in Excel — same syntax and arguments.
ISNA(value)The ISNA function is part of the IS family of functions. It specifically identifies the #N/A error, which typically occurs when a lookup function cannot find a matching value. It returns TRUE if the cell contains #N/A, and FALSE for any other value or error type.
=ISNA(NA())Result: TRUE
The NA() function generates the #N/A error, so ISNA returns TRUE.
=ISNA(5)Result: FALSE
Since 5 is not an #N/A error, the function returns FALSE.
No, ISNA only returns TRUE for the #N/A error. Use ISERROR to detect all error types.