ONLYOFFICE NA Function: Mark Unavailable Results with #N/A
Learn the zero-argument NA function in ONLYOFFICE Spreadsheet Editor with missing-data flags, IFNA error handling and auditable fixtures.
Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in ONLYOFFICE Spreadsheet Editor. How formula examples are checked
Purpose: Return the actual #N/A error value to mark a result as unavailable or intentionally missing.
Quick answer: deliberately mark a value unavailable
Type =NA() into a cell to produce the real spreadsheet error #N/A, not the literal text characters #N/A. The ONLYOFFICE NA function reference specifies no arguments. A workbook can use this to show that an expected result is missing rather than silently substituting zero, which might incorrectly enter calculations.
NA() can be intentional; seeing an error does not automatically mean the formula itself is defective. Use the surrounding business context to decide whether an unavailable value is expected.
Syntax and required arguments
=NA()
| Parameter | Required | Explanation |
|---|---|---|
| (none) | — | The function has zero inputs. Retain the empty parentheses. |
Do not write =NA(0) or treat NA as a test of another cell. To test for the #N/A error, use ISNA(value). To replace it with a message, use IFNA(value, value_if_na). The nested IFNA example uses an English-comma separator; localized editors may require a different delimiter or translated function name.
Hands-on example: missing supplier prices
In A1:B5, build this small dataset. Rows represent quotations; zero would mean a quoted price of zero, which is not the same as unavailable.
| Row | A: Supplier | B: Price (enter this) | Expected display in B |
|---|---|---|---|
| 2 | Alpha | 12 |
12 |
| 3 | Beta | =NA() |
#N/A |
| 4 | Gamma | 14 |
14 |
| 5 | Delta | =NA() |
#N/A |
Now enter the following in C2 and fill through C5:
=IFNA(B2,"Not quoted")
Expected C2 12, C3 Not quoted, C4 14, C5 Not quoted. This separates the source column (which preserves the missing-value error) from the presentation column (which shows a readable label). The official IFNA page documents its replacement rule.
Inspect the difference with error tests
Enter the following independent formulas in spare cells:
| Formula | Expected result | Why |
|---|---|---|
=NA() |
#N/A |
Emits the error value. |
=ISNA(NA()) |
TRUE |
This test includes #N/A. |
=ISERROR(NA()) |
TRUE |
General error test also includes #N/A. |
=ISERR(NA()) |
FALSE |
ISERR explicitly excludes #N/A. |
=IFNA(NA(),"Not quoted") |
Not quoted |
Replaces only a #N/A result. |
=IFNA(15,"Not quoted") |
15 |
Leaves a non-error value alone. |
=ISNA("#N/A") |
FALSE |
Quoted characters are text, not an error. |
The visible value #N/A can therefore have two different origins: a genuine error returned by a formula, or plain text copied from another system. Use the formula bar and ISNA to distinguish them when troubleshooting.
Advanced pattern: preserve a data-quality trail
Suppose status is recorded in D2 and the corresponding numeric measurement is in E2. For a row whose D2 contains Pending and whose measurement is not yet available, use:
=IF(D2="Pending",NA(),E2)
Expected result when D2 is Pending: #N/A. When D2 is Complete and E2 is 21, expected result: 21. The conditional status is explicit, and it allows downstream reports to detect unavailable results rather than mistaking them for observed zeroes.
Place the status formula above in F2. For a report display, put this formula in G2:
=IFNA(F2,"Awaiting result")
This returns Awaiting result only for #N/A, leaving unrelated calculation errors visible. Compare with IFERROR, which has a broader catch-all rule; masking every error can hide genuine reference or calculation problems.
Troubleshooting and limitations
| Problem | Explanation | Recommendation |
|---|---|---|
#N/A appears after entering NA |
That is its intentional return value. | Do not replace it automatically unless a reporting policy calls for a readable label. |
A value typed as #N/A behaves differently |
It might be literal text, depending on how it was entered/imported. | Inspect the source/formula bar; compare ISNA(A2). |
=NA(1) does not work |
NA has no required or optional arguments. | Use the exact =NA() form. |
An average or arithmetic formula sees #N/A |
Errors can propagate into dependent calculations. | Decide whether to exclude, replace or surface missing records before aggregating. Validate on the target version. |
| IFERROR hides serious problems | IFERROR catches more than missing values. | Prefer IFNA for a specifically unavailable result. |
| Localized copy/paste of IFNA fails | Argument separators or function names differ. | Use the function wizard and record locale settings. |
Important cross-compatibility distinction
Microsoft’s Excel documentation describes the same zero-argument NA() purpose; the basic syntax is consistent with ONLYOFFICE’s help. That comparison is documentation-only, not proof of error propagation or chart behaviour in every Excel/ONLYOFFICE workbook or platform. Do not assume charts automatically omit #N/A without testing the intended chart type and build.
Official documentation and claim-by-claim checking
The exact function description and syntax are documented in ONLYOFFICE’s NA reference; the ONLYOFFICE Insert Function index lists it under the Information category. Both were checked on 2026-10-13 UTC. The index is unversioned online documentation, not an independently confirmed feature matrix for every Docs web, Desktop Editors or mobile version.
| Claim | Source | Verification |
|---|---|---|
Exact NA syntax and main return rule |
NA function reference | Documentation check only |
| Placement in vendor function inventory | Insert Function index | Documentation check only |
| English Formula-tab/manual entry and comma separators | Insert Function guide | English documentation check; locale variations untested |
| Cross-software context | Microsoft support | External documentation comparison only; not native compatibility test |
Verification limits: All table and advanced examples were independently classified from documented type/error rules and explicit inputs. No native ONLYOFFICE execution, localized formula test or cross-editor import test was performed. Blank, formula-empty and array edge cases remain qualified where noted.