ISERROR Function in ONLYOFFICE Spreadsheet Editor: Formula, Examples, Errors

Use =ISERROR(value) when you need a TRUE/FALSE answer to whether a cell or expression evaluates to a spreadsheet error. In English ONLYOFFICE syntax, one required parameter named value is supplied. It recognizes error values including #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, and #NULL!; ordinary numbers, text, and Boolean values do not satisfy this test. The list and syntax come from the official ISERROR documentation. This guide’s outcomes are expected, not native-tested.

=ISERROR(value)

The output is logical TRUE for an error and FALSE otherwise. ISERROR does not fix the faulty calculation or return the underlying number. Its seven recognized error tokens are enumerated in the vendor’s function-specific help. The function is categorized as Information, unlike error-replacing IFERROR in Logical functions.

Start in a blank workbook. Enter the inputs as formulas where shown. Use =NA() rather than typing #N/A as text. Put the test =ISERROR(A2) in B2 and fill down through B7.

Place =ISERROR(A3) in D2: the expected value is TRUE. Place =ISERROR(A6) in D3: the expected value is FALSE. These distinguish error tokens from error-looking text without relying on hidden row types or screenshots.

Independent validation: the classification above follows the vendor’s enumerated error categories and elementary arithmetic; 8÷2=4, 5÷0 is invalid arithmetic, and SUM(2,3)=5. There was no native execution in ONLYOFFICE.

For an imported ledger, keep A as the original calculation and B as a Boolean audit column. In B2 enter:

=ISERROR(A2)

In C2 enter:

=IF(ISERROR(A2),"Check calculation",A2)

If A2 is =5/0, C2 is expected to display Check calculation, but A2 still exposes #DIV/0!. If A2 is =8/2, C2 is expected to show 4. This is more auditable than replacing the original formula directly. The outer IF syntax is a distinct logical-function feature and should be verified with the actual editor version before using at scale.

What ISERROR is not: three nearby tools

ISERR is also documented by ONLYOFFICE but excludes #N/A; it is a separate function, not an alias of ISERROR. See ISERR, ISNA, and IFERROR.

• A formula returning #REF! or #NAME? needs diagnosis; knowing ISERROR is TRUE does not reveal which error arose. Inspect the source expression and formula references.
• A cell displaying the characters #DIV/0! as text is not a calculation error. If a CSV import converted error tokens into text, first inspect its types.
• A 0 denominator and a missing denominator are different data-quality problems; do not infer that all errors mean the same thing or indicate a lookup miss.
• The vendor’s brief help does not specify every multi-cell array behaviour, volatile recalculation path or formula-error coercion rule. These remain native-test requirements.
• A formula with deliberately substituted values (for example IFERROR(...)) can return a normal text value and thereby make ISERROR FALSE. Do not interpret that as proof the original formula was healthy.

This guide reflects the English, unversioned ONLYOFFICE documentation accessed 2026-10-13 (UTC). The function is listed in the official Spreadsheet Editor function catalogue. The catalogue is a published function list, not a platform/version certification matrix:

• ONLYOFFICE Docs / online Spreadsheet Editor: listed in current vendor help, but not executed in a browser-based installation for this guide. Docs 10.0 was announced on October 10, 2026; that announcement does not prove these results for every earlier Docs build.
• ONLYOFFICE Desktop Editors: the desktop changelog has a 9.4.0 entry dated May 19, 2026, but it does not identify the first implementation of this particular function. No Windows, macOS, or Linux Desktop build was executed. Do not treat documentation presence as proof of feature parity.
• Mobile/integrations: not tested. The page does not claim all connectors or mobile editions have identical calculation behaviour.
• Language and separators: the Advanced Settings guide documents Formula Language, regional formats, and separator controls. The function-entry guide shows English function names and commas for multi-argument calls. Each top-level function here has one required argument, so it has no internal list separator, but surrounding IF or IFERROR formulas use English comma-separated syntax. Localized formula names, input delimiters, data-import types, or output display can vary. Adjust formulas to the actual editor settings instead of blindly swapping punctuation.

Validation declaration: examples are documented or independently reasoned expected outputs, not results observed from ONLYOFFICE. For the comparison-function cases, only formula specifications—not a live workbook—were checked.

1. Open a new test workbook and enter the exact formulas above into the specified cells (not an existing production workbook).
2. Verify that formula cells begin with =. A cell containing the literal text "#N/A" is not the error generated by =NA(); a number stored as text may look numeric but is a different type.
3. Reproduce the simple direct-expression test first, then the reference-cell test. Compare cell types, not just displayed formatting; distinguish an actual spreadsheet error from text that spells an error name.
4. Confirm English formula language and your argument separators in advanced settings. If your version reports an unknown function, confirm application version and support from the vendor—do not rename a function based on a guessed alias.
5. If a sample differs from the table, preserve the workbook and record editor product (Docs web/server or Desktop), exact build, operating system, locale, formula, and resulting observed cell value. Such observations are necessary before asserting platform-specific behaviour.

Common pitfalls

• A leading apostrophe or preformatted Text cell can store =IS... as literal text instead of calculating it. Change the cell type, re-enter the expression, and test again.
• A quoted error string such as "#N/A" is not an error result. Generate a genuine error with =NA() or =1/0 in the fixtures.
• A blank cell, zero, and the empty string ("") differ. This is especially relevant when validating imported CSV data or formulas returning empty-looking outputs; do not infer type from cell appearance.
• Error tests and error handling are different operations. An IS* function answers TRUE/FALSE; IFNA or IFERROR substitutes a fallback. Use substitution only after deciding whether an error is expected or should be investigated.
• Do not hide an unexpected error during auditing. A source input with a genuine #REF! may mean the workbook structure is broken. A user-facing fallback can mask this issue unless you keep an audit column.

These functions have counterparts in Microsoft Excel and other spreadsheet applications, but identical spellings do not guarantee identical error propagation, coercion, locale, or array behaviour in every version. The examples are documented for ONLYOFFICE’s English current help, not a tested cross-application equivalence guarantee. For a migrated workbook, verify sample outcomes natively in both source and destination applications.

Native ONLYOFFICE execution and cross-version import behavior remain untested. Preserve source formulas and verify the cases that matter to your workbook in the installed editor.

Official sources and checking dates

• ONLYOFFICE ISERROR function reference — official purpose, required argument, syntax, classification, and documented return rule. Accessed 2026-10-13 UTC; unversioned English documentation.
• ONLYOFFICE Spreadsheet Editor — Inserting functions — formula insertion, function list and comma-separated English examples. Accessed 2026-10-13 UTC.
• ONLYOFFICE Spreadsheet Editor — Advanced Settings — formula language, regions and separators. Accessed 2026-10-13 UTC.
• ONLYOFFICE Desktop Editors changelog — Desktop release-history context, not feature-by-build certification. Accessed 2026-10-13 UTC.
• ONLYOFFICE Docs 10.0 announcement, October 10, 2026 — product-version context, not native test evidence. Accessed 2026-10-13 UTC.

Verification: Official syntax and all example classifications were independently checked. No native application or localized execution was performed.