ERFC in ONLYOFFICE: Complementary Error Function and Gaussian Tails

• Introduced: The original introduction version and date are not established by the official sources checked.
• Availability: Documented in the current ONLYOFFICE Spreadsheet Editor help; no final working-version endpoint is established.
• Scope: Docs and Desktop Editors release separately. This unversioned help does not establish availability in every older build, mobile client or deployment.
• Checked: October 14, 2026, against the official function reference. Documentation check; not a new native test.

ERFC helps calculate normalized Gaussian tail areas that arise in diffusion, signal processing, measurement uncertainties and error-function models. Unlike ERF with its one-argument 0-to-x interpretation, ERFC directly represents the complementary integral from x to infinity. This distinction matters for positive large x, where computing 1-ERF(x) numerically can lose precision if ERF is already extremely close to 1.

For negative real x, ERFC(x) can be greater than 1. That is mathematically correct, not automatically an error. At x=0 it equals 1; it approaches 0 as x increases and 2 as x decreases. These are mathematical definitions and limits; ONLYOFFICE-specific numerical overflow/underflow thresholds have not been tested.

=ERFC(x)

=ERFC(A2) is valid under documented English syntax; =ERFC(A2,B2) does not follow the vendor’s signature. The related ERFC.PRECISE(x) function has a separate canonical name and is not a second argument, suffix, or implicit alias. Official ERFC.PRECISE reference. The documentation does not specify how this function coerces text, blank cells or logical arguments; no such native results are invented.

1. Create a blank spreadsheet in an ONLYOFFICE Spreadsheet Editor edition you can identify. Use English formula language for the formulas below. Record your Desktop version or the actual Docs/server version and your region if you later report test results.
2. Enter the specified headers, then enter the table’s input values in the exact cells shown. Numeric inputs must be numeric cells (without quote marks).
3. Enter the formulas into the output cells exactly as shown, beginning with =. Use Formula → Function to find ERFC or type the function directly. Fill down only through the named last row; do not accidentally include table headers.
4. Compare your displayed values against the independently computed expected column. For decimals, change display format or use numeric tolerance rather than expecting identical trailing digits.
5. If your result differs, record the formula, underlying cell type, software platform/version, displayed result, separator/locale settings and any error without overwriting the expected-value reference. ONLYOFFICE’s formula-entry and recalculation guide describes recalculating via the Formula tab, or F9 for the workbook.

Put Input x in A1, ERFC result in B1, Independently expected in C1 and Complement check in D1. Enter the numeric x values in A2:A14 from the following table; enter =ERFC(A2) in B2 and fill to B14. Type the listed numeric expectations in C. In D2, the proposed formula =ERF(A2)+ERFC(A2) should mathematically approximate 1; fill to D14. Use =ABS(B2-C2)<0.000001 as a proposed numeric tolerance check, not a claimed native observation. For the row at x=4, display extra decimal places or scientific notation rather than rounding away the small expected output.

The expected values were computed separately using math.erfc and a high-precision mathematical library; 13 direct values and 13 independent complement identities were cross-checked. Scientific-style small values are written explicitly so they are not mistaken for zero due to display formatting. No screenshot was used to derive any value.

Mathematically, =ERFC(A2) equals =1-ERF(A2) for real x. However, when x is sufficiently positive, ERF(x) is extremely close to 1 and the subtraction of two nearby floating-point numbers may lose significant digits. For tail calculations, use the documented ERFC function when direct complementary values are the quantity needed. This is a numerical-analysis recommendation based on the mathematical definitions, not a measured speed or accuracy benchmark in ONLYOFFICE.

A deliberately extreme value such as x=10 has a mathematically tiny complementary error function (~2.09e-45). Whether a particular ONLYOFFICE build returns a nonzero numeric value, zero, or an error at that magnitude is NOT TESTED. Avoid listing any such result as verified native behaviour. The worksheet table stops at x=4 to keep comparisons interpretable.

The standard normal CDF is mathematically Phi(z)=0.5*erfc(-z/sqrt(2)). For a z-score in A2, the proposed formula

=0.5*ERFC(-A2/SQRT(2))

computes that transformation, assuming the documented functions are available in the target edition. It is not a vendor-approved probability workflow and has not been executed natively; users needing probabilistic analysis should independently check the model and input assumptions. For z=0, mathematical expectation is 0.5. The SQRT function is separately documented.

erfc(-x)=2-erfc(x) is a mathematical identity. Thus erfc(-1) is approximately 1.842700793 while erfc(1) is approximately 0.157299207. If the result is bigger than 1, do not clip it to 1, because the complementary error function is not itself a bounded [0,1] probability for every real input. The normalized integral of a Gaussian tail has a particular probabilistic interpretation only after the correct variable transformation.

Keep the physical measurement, its scale/standard deviation, and the dimensionless argument x in separate columns. ERFC takes the already-computed dimensionless numeric argument, not a string such as "2 seconds" or a raw engineering unit. For a one-sided normal tail at standard-normal z, mathematically 0.5*ERFC(z/SQRT(2)) gives the right-tail probability. Label the input domain clearly. If z is computed from measured data, document the meaning of the standard deviation and assumptions; this reference is about the function, not a substitute for validating a statistical model.

Do not invent an error value. Where a case is mathematically defined but the editor’s coercion/overflow handling is undocumented, record it as native behaviour unverified, not a guaranteed #VALUE!, #NUM! or other message.

ERF calculates one-argument error integrals and an optional two-bound form; ERFC.PRECISE is separately documented with a single argument; ERF.PRECISE is a distinct single-argument function. SQRT appears in standard-normal transformations. Do not merge ERF, ERF.PRECISE, ERFC, or ERFC.PRECISE into duplicate URLs: they are distinct vendor-documented canonical names.

Officially documented: The current, unversioned English ONLYOFFICE Docs Spreadsheet Editor function page for ERFC and Insert Function catalogue list ERFC as an Engineering function. Checked 2026-10-13 (UTC). This supports the existence, purpose and signature of the function in the documented editor; it is not proof of identical behaviour in all past web integrations, all Desktop Editors builds, or mobile versions.

First-supported version: Not established by this research. The vendor maintains distinct Docs release history and Desktop Editors release history. Their availability does not, by itself, identify the first supported release of ERFC. Desktop version compatibility: NOT NATIVELY TESTED; browser/web version compatibility: NOT NATIVELY TESTED; historical versions: UNKNOWN; imported workbook round-trip and specific file-format compatibility: NOT TESTED.

English formulas: Examples use an initial = and commas between arguments where necessary, following the official Insert Function instructions. Under File → Advanced Settings, the editor offers Formula Language, Region, and decimal/thousands separators (official Advanced Settings guide). Translated formula names, regional separators and localized decimal entry are not verified here. Do not blindly swap commas for semicolons or translate a function name unless checked in the actual target installation.

Evidence classification: Every result labelled expected is derived from independent mathematical or logical computation, never copied from an ONLYOFFICE screenshot or claimed to have been observed in a running editor. Native Desktop executions: 0. Native web executions: 0. Any error strings described as possible diagnostic are not observed output.