Checks whether a value is the #N/A error and returns TRUE or FALSE.
Syntax
ISNA(value)Argumente
valueerforderlich
The value or reference you want to test for the #N/A error.
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())→TRUEThe NA() function generates the #N/A error, so ISNA returns TRUE.
=ISNA(5)→FALSESince 5 is not an #N/A error, the function returns FALSE.
Select the cell
Click on the cell where you want to display the result.
Enter the formula
Type =ISNA(A1) where A1 contains the value you want to check.
Press Enter
Press Enter to see if the cell contains the #N/A error.
No, ISNA only returns TRUE for the #N/A error. Use ISERROR to detect all error types.