Contact
12 programs
Explore the site

ERFC Function (LibreOffice Calc)

Statistical Intermediate LibreOffice Calc Introduction not established

The ERFC function returns the complementary error function, used in probability, statistics, Gaussian tail modeling, and engineering applications.

Verification status: Consult the documentation, examples and any stated test scope below. How formula examples are checked

Availability and version history

  • Introduced: Documented by LibreOffice 26.8.1.1; original introduction not established.
  • Availability: Supported in LibreOffice 26.8.1.1, verified against its function registry. This identifies a supported release, not a final working version.
  • Scope: Desktop Calc, using the English function name. Availability in other spreadsheet applications is separate.
  • Checked: 2026-10-14 — function reference; versioned support. Documentation/source check; not a new native test. Existing example-specific test claims below retain their stated scope.
The **ERFC** function returns the **complementary error function**, defined as \(1 - \text{ERF}(x)\). It is widely used in probability, Gaussian tail modeling, diffusion equations, and engineering analysis.

What the ERFC Function Does

  • Computes the complementary error function
  • Represents the upper tail of the Gaussian distribution
  • Useful in probability, statistics, and engineering
  • Handles any real input value

Syntax

ERFC(x)

Arguments

  • x:
    The value at which to evaluate the complementary error function.

Mathematical Definition

[ \text{ERFC}(x) = 1 - \text{ERF}(x) ]

[ \text{ERFC}(x) = \frac{2}{\sqrt{\pi}} \int_x^\infty e^{-t^2} , dt ]

Basic Examples

Standard complementary error function

=ERFC(1)
→ 0.15729921

Negative input

=ERFC(-1)
→ 1.84270079

Zero input

=ERFC(0)
→ 1

Large positive input

=ERFC(5)
→ very small number (close to 0)

Advanced Examples

Convert ERFC to normal distribution tail probability

=0.5 * ERFC(x / SQRT(2))

Compute probability between two z‑scores

=0.5 * (ERFC(a / SQRT(2)) - ERFC(b / SQRT(2)))

Use ERFC in diffusion/heat‑transfer modeling

=ERFC(x / (2 * SQRT(D * t)))

Use ERFC for smoothing/activation functions

=0.5 * ERFC((threshold - A1) / width)

Approximate survival probability in Gaussian models

=ERFC(z / SQRT(2)) / 2

Edge Cases and Behavior Details

ERFC returns a number between 0 and 2

Behavior details

  • ERFC(∞) → 0
  • ERFC(–∞) → 2
  • ERFC is monotonic decreasing
  • ERFC(x) = 1 – ERF(x)
  • Inputs can be any real number

Invalid input → Err:502

Common Errors and Fixes

Err:502 — Invalid argument

Cause:

  • Non‑numeric input
  • Invalid references

Fix:

  • Wrap with VALUE()
  • Validate numeric ranges

Unexpected values > 1

Cause:

  • Negative input (ERFC can return up to 2)

Fix:

  • Confirm sign of x

Best Practices

  • Use ERFC for Gaussian tail probabilities
  • Use ERF for central cumulative probabilities
  • Convert ERFC to normal CDF with 0.5 * ERFC(x/SQRT(2))
  • Use ERFC in diffusion and heat‑transfer equations
  • Document units and scaling in engineering models
ERFC is essential for modeling Gaussian tail probabilities and diffusion processes — it complements ERF and unlocks advanced statistical and engineering workflows.
  • ERF — central error function
  • NORMDIST / NORMSDIST — normal distribution functions
  • EXP — exponential
  • SQRT / PI — supporting math
  • Custom integrals — advanced modeling

By mastering ERFC, you can build precise statistical, probabilistic, and engineering models in LibreOffice Calc.