ISNA Function (OpenOffice Calc)

ISNA checks specifically for the #N/A (Not Available) spreadsheet error. It returns TRUE when its input evaluates to #N/A and FALSE for an ordinary value or a different error. Use it when a lookup or another data source reports not available and you need to distinguish that situation from, for example, division by zero. Apache’s dedicated ISNA page documents this distinction explicitly. [O1]

=ISNA(NA())

Expected: TRUE. Apache documents this exact example; NA() deliberately returns #N/A. [O1][O2]

=ISNA(1/0)

Expected: FALSE, not TRUE: division by zero produces #DIV/0!, a different error category. This is another example given directly by Apache. [O1]

=ISNA(value)

The official syntax lists one positional argument and no optional parameters. The function returns a logical TRUE or FALSE, not the underlying value, a text label, or a replacement calculation. Because it takes only one argument, ISNA itself has no argument separator. Nested Calc examples here follow Apache’s published semicolon syntax (;) for multi-argument IF and VLOOKUP formulas. Formula names and separators may be displayed differently in localized installations; check the Function Wizard in your own installation instead of assuming an Excel/LibreOffice formula can be pasted unchanged. [O1][O4][O5]

Software and version context: Apache OpenOffice Calc desktop. On 2026-10-12, Apache’s official download page identified 4.1.16 as its released download. The Apache wiki function help provides direct documented support for ISNA; it is an historical documentation source rather than evidence that this particular worksheet was executed in 4.1.16 on Windows, macOS or Linux. No platform-specific behaviour was independently tested. [O1][O7]

Enter each of these formulas in an empty cell. There is no sample data to prepare. All three results appear in Apache’s ISNA documentation (the third uses a text cell, shown here as a text literal for clarity). [O1]

Validation label: documentation check against [O1] plus reasoning from the documented predicate; native Calc execution not performed. Results are expectations, not screenshots or measured outputs.

Create a new worksheet. Enter the following input values in column A exactly as specified. For rows that begin with =, type the formula including the equals sign. Do not enter column B values manually; enter the formula in B2 and copy it downward, or type each formula directly.

The first two expected results follow Apache’s published examples directly. The remaining rows are documentation-based logical deductions, not native observations. In particular, ="#N/A" evaluates to a string that happens to look like an error; NA() evaluates to the actual error. This difference is useful when importing CSVs or copying data from external reports. [O1][O2]

To check your setup, click A2 and confirm that the formula bar shows =NA(). If instead A2 holds the characters #N/A as text, the test is not equivalent. Similarly, don’t replace A6 with a space: that would be nonempty text, even though the ISNA test still should be FALSE. This table is intentionally small so you can see each case independently.

Suppose an upstream calculation occupies B2. In C2, enter:

=IF(ISNA(B2);"Not available";B2)

The official syntax of IF(test; value1; value2) selects the first branch if the test is true and the second if false. Apache documents that the unchosen branch is not evaluated. In this combined formula, only #N/A triggers the message; an ordinary number passes through. A different spreadsheet error is not deliberately hidden by this ISNA-only test, although precise error propagation in unusual nested formulas still requires native testing. [O1][O4]

Validation label: the logic is checked against [O1][O2][O4]. Native Calc execution—including the exact displayed error rendering—was not performed. Avoid treating the fallback message as proof that data is really absent until you investigate the source of the #N/A.

Create the following lookup table in the same sheet. Values in column B are numeric inventory counts; row 1 contains headers, not data.

In E2, type P99 (a code not present in the table). In F2, enter:

=ISNA(VLOOKUP(E2;$A$2:$B$5;2;0))

Expected: TRUE. VLOOKUP searches the leftmost column for the value in E2, retrieves column 2, and with mode=0 uses exact-match lookup. Apache documents that VLOOKUP returns #N/A when no exact match is found; ISNA identifies that condition. [O1][O5]

To show a friendly message in G2, enter:

=IF(ISNA(VLOOKUP(E2;$A$2:$B$5;2;0));"Code not found";VLOOKUP(E2;$A$2:$B$5;2;0))

Expected: Code not found for P99. Then change E2 to P11. Expected: FALSE in F2 and 8 in G2. These are documentation-derived results, not native-observed results. [O1][O4][O5]

The last parameter 0 is important: omitting mode in Apache’s documented VLOOKUP changes the search to sorted/approximate mode, which is inappropriate for an unordered inventory-key list. Keep the dollar signs in $A$2:$B$5 if you plan to copy the formula. Avoid wildcard or regular-expression query strings in this example: Apache’s VLOOKUP page notes that matching options can alter results. [O5]

A lookup that has a matching key but contains an error in the returned quantity cell is a different data-quality problem. Do not automatically label every spreadsheet error “not found”; inspect the underlying table or use more targeted checks.

Apache explicitly distinguishes these three tests. ISNA tests only #N/A; ISERR detects errors except #N/A; ISERROR detects all errors, including #N/A. Use the predicate that matches the decision you intend, not whichever name sounds most general. [O1][O3][O6]

• A message appears when you expected a number: The lookup returned #N/A or your source cell contains =NA(). Inspect the source formula and its references instead of automatically treating missing values as zero. [O1][O2][O5]
• FALSE appears even though something is wrong: ISNA deliberately ignores errors other than #N/A. Use ISERROR for a broader check or ISERR to detect other errors without counting #N/A. [O1][O3][O6]
• You see the characters #N/A but ISNA returns FALSE: Check whether the cell contains actual error output or a text string (="#N/A"). Matching characters on the screen are not proof of identical cell types. [O1][O2] (documentation-derived inference)
• The lookup behaves unexpectedly: In VLOOKUP, provide 0 for exact mode and inspect the data range, duplicate keys, and Calc matching settings. Approximate mode and regular-expression options are documented sources of surprises. [O5]
• An imported formula is rejected: Confirm that it begins with =, that the function name is available in your installed language, and that nested multi-argument functions use the separators supported in that installation. The official Apache syntax uses ; for IF and VLOOKUP, not a comma. [O4][O5]
• Blank cells and error codes: Blank is not #N/A by definition. To distinguish blankness specifically, use ISBLANK. Never assert that a blank cell always behaves like zero in every unrelated Calc formula. [O1][O6]
• Edge-case formula errors: Apache’s ISERROR reference documents a nested CHOOSE case where an error propagates rather than producing a Boolean as expected. That case is about ISERROR; it is not a native test of ISNA. Any similar complex nesting used in critical workbooks should be tested in your target Calc build before relying on it. [O3]
• No replacement default: ISNA returns a Boolean; it does not accept a default replacement text or number argument. To display a message, combine it with IF as shown above. [O1][O4]

This page relies on Apache OpenOffice documentation for function support. ISNA(value) is documented by Apache for Calc, with actual #N/A examples. No Excel or LibreOffice functionality is assumed to exist just because a similarly named function exists there. If exchanging files with other spreadsheet programs, test localized formula names, error representations, semicolon/comma separators, lookup settings, and results in the receiving program. We have not established a full version-by-version compatibility matrix or executed this guide on Windows, Linux, or macOS. [O1][O5][O7]

• ISERR — tests other errors but excludes #N/A.
• ISERROR — tests any error including #N/A.
• NA — deliberately generates the #N/A error.
• IF — chooses a display value based on a condition.
• VLOOKUP — retrieves a table value or returns #N/A when no exact match exists.
• ISBLANK — checks whether a cell is truly empty.

All official pages listed below were checked on 2026-10-12. The wiki pages are historical Apache-maintained reference material. The examples above are marked expected, and no screenshot or native testing is claimed.

• [O1] Apache OpenOffice Calc: ISNA function — exact syntax, #N/A scope, and documented example results. Apache wiki last edited 2024-01-31; see its page history.
• [O2] Apache OpenOffice Calc: NA function — NA() has no arguments and returns #N/A.
• [O3] Apache OpenOffice Calc: ISERROR function — detects all errors; also documents a nested CHOOSE propagation limitation.
• [O4] Apache OpenOffice Calc: IF function — IF(test; value1; value2) order, defaults, and branch evaluation.
• [O5] Apache OpenOffice Calc: VLOOKUP function — argument order, mode 0 exact matching, #N/A for misses, matching settings.
• [O6] Apache OpenOffice Calc: Information functions — meaning of ISNA, ISERR, ISERROR and ISBLANK.
• [O7] Apache OpenOffice official download page — released version 4.1.16 at access date.

The examples show expected results checked against Apache OpenOffice documentation and independent arithmetic, text mapping, or logical reasoning. They were not run in Apache OpenOffice Calc. Platform, locale, import, and unusual error cases are not certified.