ISNA Function in Microsoft Excel: 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 Microsoft Excel.

Example 1: Detect a deliberate missing-value marker

=ISNA(NA())

Expected result: TRUE.

NA() produces the actual #N/A error, so the narrow predicate is TRUE.

Example 2: Do not classify division by zero as missing data

=ISNA(1/0)

Expected result: FALSE.

The expression fails, but its error is not #N/A. A separate error flag is needed for this condition.

Example 3: Distinguish a text label

=ISNA("#N/A")

Expected result: FALSE.

The quoted characters are a label, not an error-typed value.

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.

Microsoft’s grouped IS-function reference distinguishes ISERR, ISERROR and ISNA and explains that the tests do not convert quoted text into the corresponding value type. Keep the actual lookup result separate from a display label such as “not found”. 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 Google Sheets 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 Microsoft Excel 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 Microsoft Excel 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.