Skip to content
Excel

ERFC function in Excel

Returns the complementary error function

=ERFC(x)

ERFC syntax and parameters

One argument, one required.

  • xnumberRequired

    The lower bound for integrating ERFC.

ERFC examples

Formulas you'll actually reuse.

  1. The complementary error function 1 − ERF(x) — a Gaussian tail:

    =ERFC(B2)

    Result0.1573

  2. The two-sided tail probability of a z-score — P(|Z| > z):

    =ERFC(B2 / SQRT(2))

    Result0.3173

ERFC in Google Sheets

Same name — your formula ports as-is.

Try ERFC in the playground

Edit the example — nothing to install.

Preloaded with the ERFC formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Excel gets this done.