ONLYOFFICE ISERR: Find Errors Without Flagging #N/A

=ISERR(A2) reports TRUE when A2 evaluates to an error other than #N/A. It reports FALSE for an ordinary number, text, Boolean, blank cell, or #N/A. This distinction is useful in imported-price audits: an unavailable lookup can be a normal business condition, but division by zero may need repair. The ONLYOFFICE ISERR reference explicitly excludes #N/A.

Do not confuse these three checks. ISERR excludes #N/A; ISNA checks only #N/A; ISERROR checks either category. ISERR does not fix a broken formula or convert an error into a replacement result: it only classifies the test value.

=ISERR(value)

The official English reference uses a single argument, so no comma separator is involved in a basic ISERR call. An outer IF uses commas in the English help; in a localized editor, verify the locale-specific function spelling and argument separator before copying nested examples. ISERR() without a value is not a supported form in the checked documentation.

Create the following table in a blank sheet. In column A, enter exactly what the Input column says; =... is a formula. Leave row 6’s A cell physically empty. Put =ISERR(A2) into B2, then copy or fill it down to B6.

Expected result, not native output: Values above follow the documented error-classification rule and a separately reasoned fixture table. The examples have not been executed in ONLYOFFICE Docs or Desktop Editors.

Fast tests without a sample table

=ISERR(1/0)
=ISERR(NA())
=ISERR(4+5)

Expected results in order: TRUE, FALSE, FALSE. These formulas test the expression directly; the error does not have to be stored in a separate cell. Use the matching error functions only for an error classification—not to assert that the underlying calculation is trustworthy.

For A2:A6 above, enter in C2 and fill down:

=IF(ISNA(A2),"Missing data",IF(ISERR(A2),"Fix formula","OK"))

Expected C2 Fix formula, C3 Missing data, C4 OK, C5 OK, C6 OK. The order is deliberate: handle #N/A with ISNA before checking other errors with ISERR. This makes an audit easier to understand than a blanket IFERROR that replaces every error with the same message.

To flag any error, including #N/A, use:

=IF(ISERROR(A2),"Needs review","OK")

For A2 (#DIV/0!) and A3 (#N/A), the expected result is Needs review. For A4 (16), it is OK. The difference between these two workflows is meaningful, especially when #N/A indicates a legitimate missing lookup rather than corrupt arithmetic.

Avoid claiming that ISERR repairs references or identifies the specific kind of non-#N/A error. ONLYOFFICE also documents ISERROR and ISNA; their different rules form the reliable comparison here.

Microsoft’s Excel IS-functions reference also defines ISERR as excluding #N/A; this independently confirms the documented classification, not an execution test on an imported Excel workbook. This guide intentionally makes no claims about Google Sheets, LibreOffice, desktop release numbers, Android/iOS or behaviour of all imported error codes beyond the checked ONLYOFFICE documentation.

The exact function description and syntax are documented in ONLYOFFICE’s ISERR 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.

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.