ISNA Function in Google Sheets: Examples, Pitfalls & Compatibility

=ISNA(value)

value (required): A value, formula result or reference to the single cell being classified.

Examples use English function names, comma argument separators and decimal points. Adapt formula separators to your workbook settings, not punctuation inside quoted text.

Use ISNA when a missing lookup result should be distinguished from an invalid reference or failed arithmetic. It answers a narrow type question rather than deciding whether a record is otherwise acceptable.

Each example is independent. Where input cells are listed, enter those values first; otherwise the formula is self-contained. Expected outputs are independently checked calculations or documented error expectations, not captured results from Google Sheets.

Example 1: Recognize the missing-value error

=ISNA(NA())

Expected result: TRUE.

This tests the error value, not its appearance in a cell.

Example 2: Reject a different kind of error

=ISNA(SQRT(-25))

Expected result: FALSE.

A negative real square root fails, but it is not a #N/A missing-value error.

Example 3: Inspect a textual import value

=ISNA("#N/A")

Expected result: FALSE.

An import can contain the characters #N/A as ordinary text. The predicate does not promote that text into an error.

Create a diagnostic column beside the calculation being checked and fill down one row at a time. Test a known numeric result, a deliberate #N/A, a division error and a quoted error label before using the flag in a larger report. Do not overwrite the underlying calculation while investigating. Once the desired replacement policy is clear, IFERROR or IFNA may provide a more direct presentation formula.

Quoted error text is not detected as an error. A string such as “#N/A” is ordinary text. An actual error value is a different data type.

A FALSE result is treated as proof the input is valid. A predicate only tests its named error condition. Text, blanks and out-of-range business values can still require separate validation.

A useful diagnostic disappears. Do not replace every error with zero without considering the meaning. Preserve enough information to distinguish missing data from a broken calculation.

Google provides a separate reference for this predicate. In a shared validation sheet, label its output according to the exact condition tested rather than using an ambiguous heading such as “good row”. See the vendor reference for the current definition.

Both official references distinguish actual errors from normal text and distinguish the scope of these three predicates. The classic error cases here do not certify the treatment of every newer, application-specific error or a complex array formula.

Compare the ISNA guide for Microsoft Excel and its official documentation. Having a guide in both libraries establishes two documented references, not a certificate of identical behavior across releases, locales or file conversions.

ISERROR, ISERR, IFERROR, IFNA · All Google Sheets functions.

Editorial verification: Official references retrieved on 2026-10-12. The three worked cases are included in this release’s reproducible Python checking suite. It checks the stated arithmetic, calendar or text model and the expected documented error classification; it is not the Google Sheets calculation engine. No native application run, UI screenshot, maximum-size benchmark or cross-version certification is claimed. Review the editorial testing standards before relying on a formula in a critical workbook.