Excel functions / Math

ERFC function

The complementary error function: 1 - ERF(x).

Syntax

=ERFC(x)

Arguments

When to use it

ERFC gives 1 minus the error function: the share of a normal distribution beyond a distance from its middle, on both sides.

Examples

  1. At 1

    ABC
    1x
    210.15730

    In C2: =ERFC(A2) → 0.15730

    Try this example

Common mistakes

ERFC in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Also written as ERFC.PRECISE.

Try ERFC in the playground

Related functions