ISNA Function (Gnumeric)

Use ISNA when an input is specifically the spreadsheet error #N/A, often meaning a missing result. It does not flag divide-by-zero or other formula errors; Gnumeric documents ISNA as the exact #N/A predicate. R1

=ISNA(value)

value (required) is a cell reference or expression to inspect. The documented result is TRUE only for the actual #N/A error value, and FALSE for any other value, including other error classes. There are no optional parameters or defaults. R1

Native-validation limits: Examples are documentation/source-based expectations, not observed Gnumeric execution or screenshots.

Version and platform: The official Gnumeric manual is labelled 1.12 and documents this Information-category function. The project announced Gnumeric 1.12.62 in the current 1.12 series. The official public catalogue lists this function as Complete with Basic project testing, which is not a claim that any examples in this guide were executed. Core Information functions are documented in Gnumeric; actual availability still depends on the reader’s installed version and environment. The introduction date in an earlier minor release was not established. R1R6

Formula notation / locales: Use a leading = in a cell; the examples use the manual’s English function names. This function requires exactly one argument and has no optional parameters or documented defaults, so there is no argument-separator ambiguity in its own syntax. In nested expressions the official formula documentation illustrates commas; operating-system locale can affect language and numeric formats, so check your Gnumeric installation if a pasted multi-argument formula is parsed differently. R4

1. Open a new worksheet. Add descriptions in A2:A6 if helpful.
2. Enter the exact =... formulas in B2:B6 shown below; do not type the displayed error labels manually.
3. Enter the matching test formulas in C2:C6. The results below are expected, not native observed.
4. Compare your installed Gnumeric results and record the local version, locale, and mismatches before adoption.

On a narrow screen, scroll sideways to view this complete example.

Reading the results: Keep real #N/A separate from text that merely looks like #N/A. This guide does not verify lookup algorithms. The classification follows the official definitions R1 and Gnumeric’s documented error/cell types R4.

Separate unavailable values from broken calculations

For a report that stores lookup/formula outcomes in B2:B6, put this in D2 and fill it through D6:

=IF(ISNA(B2),"Lookup unavailable",IF(ISERR(B2),"Fix calculation",B2))

Expected results: D2 = Lookup unavailable, D3 and D4 = Fix calculation, D5 = the literal #N/A text, D6 = 7. The outer branch tests missing values first; the other errors remain separately visible as actionable diagnostics. R1

Choose ISNA, ISERR, or IFNA intentionally

• =ISNA(NA()) → TRUE (a Boolean status flag).
• =ISERR(NA()) → FALSE (by documented exclusion).
• =ISERROR(NA()) → TRUE (all error classes).
• =IFNA(NA(),"No match") → No match (expected based on Gnumeric’s official IFNA semantics).

Choose IFNA when you want to substitute a result only for #N/A; choose ISNA when the status itself should remain available for counts, audit flags or conditional formatting. R1

• False for =1/0 or =SQRT(-1)? Correct: those are non-#N/A error types, so test them with ISERR or ISERROR. R1
• False for a cell displaying the characters #N/A? If the cell stores the quoted text "#N/A", it is not the #N/A error value. Reproduce the real value with =NA(). R1
• Missing record not flagged? ISNA does not decide whether a record should exist. The upstream lookup must actually return #N/A; inspect its exact-match/sorting options and ranges. R1
• Avoid hiding other failures: IFNA substitutes only #N/A; indiscriminate IFERROR could disguise a broken formula. Check what the source cell really contains before substituting a label. R2
• Formula parser issue: Verify the leading =, uppercase/lowercase spelling (function names are not case sensitive in Gnumeric), and the local format for nested formulas. R4

The Gnumeric 1.12 Information manual calls ISNA Excel compatible. This documents basic intent and formula naming; importing a workbook or switching application/version still deserves testing, particularly where a lookup generates #N/A differently. R1 The public catalogue reports a Complete implementation and Basic project testing for this canonical spelling; this is metadata about the project, not a site-specific validation record. R3

ISERR · ISERROR · NA · IFNA · IFERROR · VLOOKUP.

The official Gnumeric 1.12.62 source archive was checksum-verified; the Information-function callback confirms the documented error classification without requiring inference from another spreadsheet.

The following are official Gnumeric references (accessed 2026-10-12 UTC), not evidence of live testing:

• R1 Information-function manual, Gnumeric 1.12: Official synopsis, argument and behaviour.
• R2 Logic-function manual, Gnumeric 1.12: IF, IFNA and IFERROR selection semantics.
• R3 Gnumeric function catalogue: Implementation/testing classifications.
• R4 Gnumeric formulas and cell types: Formula entry and error values.
• R5 Languages and locales: Operating-system locale configuration.
• R6 Version 1.12.62 announcement: Official release announcement.
• R7 Official source archive: 1.12-series downloads.

Validation: Official documentation and checksum-verified Gnumeric 1.12.62 source were inspected; displayed logical outcomes were independently reasoned. Native Gnumeric execution, screenshots, locale regression and workbook round-trip tests were not performed.