ISNA Function in Google Sheets

Determine if a value is the

ISNA Function

The ISNA function in Google Sheets is used to check if a value is the #N/A error.

Syntax

ISNA(value)
  • value: The value or expression you want to test. This is a required parameter.

Example

  1. Check for #N/A Error

Check if a formula results in the #N/A error:

=ISNA(VLOOKUP("Z", A2:B10, 2, FALSE))

This will return TRUE if the lookup value is not found.

Notes

  • Returns TRUE only for the #N/A error.
  • Often used to handle specific cases where a value is not available.
  • IFNA: Provide a custom result if the #N/A error is encountered.
  • ISERROR: Check if a value is any error, including #N/A.