Excel functions / Math

ERF function

The error function between two limits. With one limit it runs from 0.

Syntax

=ERF(lower_limit, [upper_limit])

Arguments

When to use it

ERF gives the error function, which describes the share of a normal distribution within a distance of its middle. With two arguments it runs between two limits.

Examples

  1. ERF at 0.745

    ABC
    1x
    20.7450.70793

    In C2: =ERF(A2) → 0.70793

    Try this example

  2. Share of a normal curve within 1 standard deviation

    ABC
    1SD
    2168.3%

    In C2: =ERF(A2/SQRT(2)) → 68.3%

    Try this example

Common mistakes

ERF 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

Try ERF in the playground

Related functions