NA Function (OpenOffice Calc)

• Introduced: First release not established; documented by OpenOffice.org 3.3.
• Supported in: Apache OpenOffice 4.1.16; no final supported release is established.
• Scope: English desktop Calc, semicolon-separated formulas and local workbook references.
• Checked: October 14, 2026. Eight examples were recalculated in 4.1.16 on Linux x86-64, Build9816. Generated-ODF identities, saved results and controls were checked; no manual-entry or different-release test is claimed.

NA produces the #N/A error value to mark unavailable data. It is an intentional missing-data result, not a numeric zero and not the text string “#N/A”. This makes an unavailable prerequisite visible instead of silently replacing it with an amount that could be mistaken for valid data. Release implementation.

NA()

NA has no arguments. Its normal output is an error value. A table showing #N/A for NA() is therefore demonstrating the intended result, not claiming that the formula failed to recognize the function name.

These eight expressions are self-contained. They use NA as its ordinary missing-data value and then propagate, detect or explicitly replace that value. No malformed formulas or invalid-domain calculations are needed.

All eight formulas were recalculated. Quotation marks identify text results; unquoted #N/A identifies an error. Logical tests in the explicitly number-formatted output cells are shown as 1/0. Reference expectations follow the inspected callback, workbook structure and ordinary arithmetic.

For a field whose source has not arrived, =NA() makes the missing value explicit. The first four examples show that adding 1, passing it through SUM or selecting it with IF does not turn it into a usable number.

To show a readable status, =IF(ISNA(NA());"pending";"ready") returns the text “pending” in the tested case. A corresponding worksheet pattern can inspect a source cell instead of the inline NA call. Keep the source error and status separate so that a label does not erase the underlying missing-data condition.

=ISNA(NA()) and =ISERROR(NA()) both return true, represented by 1 in the numeric-formatted native result cells. ISNA asks specifically about the missing-data error, whereas ISERROR is the broader error test. Their matching results for NA do not make the two predicates interchangeable for every other error.

The tested =IF(ISNA(NA());0;1) returns numeric zero only because the formula explicitly chooses zero after detecting the missing-data value. That is a business-rule decision, not a property of NA itself. Use such a replacement only when zero is genuinely the intended meaning.

The saved ODF represents the intended NA error cells with a numeric-zero storage field as well as an error display. The retained GUI/XML review classified them by the actual #N/A error display and formula identity. That serialization detail must not be interpreted as an observed numeric-zero result.

Quoted "#N/A" is ordinary text; NA() is an error value. Similarly, a blank source, a true zero, an empty text result and unavailable data may require different downstream treatment.

This guide checks the displayed missing-data result, arithmetic/SUM propagation and the listed tests. Chart plotting, export to other file formats and handling in every aggregate function were not executed. Do not assume that all aggregators or charts will treat a deliberate error identically. The current dispatcher explicitly produces the missing-value error, and the observed behavior is scoped to Apache OpenOffice 4.1.16.

ISNA, ISERROR, IF.

• Function-specific implementation
• Release function description and argument metadata
• English function identity
• NA dispatcher
• ISNA callback

The generated ODF was opened in the native GUI, hard-recalculated and saved separately. The informational “Not all attributes could be read” load warning was retained. A deliberately stale SUM cache refreshed to 3, and an uncached SUM returned 7. The exact local inputs, sheet order, formula identities and saved values were reconciled. The authoring-tool XLSX and its previews were not used as native calculation evidence. Only the listed cases and release are covered.