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
lower_limit: Where to start. With no upper limit, the function runs from 0 to here.upper_limit(optional): Where to stop.
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
ERF at 0.745
A B C 1 x 2 0.745 0.70793 In C2:
=ERF(A2)→ 0.70793Share of a normal curve within 1 standard deviation
A B C 1 SD 2 1 68.3% In C2:
=ERF(A2/SQRT(2))→ 68.3%
Common mistakes
- Two arguments. ERF(a, b) is the error function from a to b, not from 0 to a times b.
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.
- Czech: ERF
- Danish: FEJLFUNK
- Dutch: FOUTFUNCTIE
- Finnish: VIRHEFUNKTIO
- French: ERF
- German: GAUSSFEHLER
- Hungarian: HIBAF
- Italian: FUNZ.ERRORE
- Norwegian: FEILF
- Polish: FUNKCJA.BŁ
- Portuguese (Brazil): FUNERRO
- Portuguese (Portugal): FUNCERRO
- Russian: ФОШ
- Spanish: FUN.ERROR
- Swedish: FELF
- Turkish: HATAİŞLEV
Related functions
- ERFC: The complementary error function: 1 - ERF(x).
- ERF.PRECISE: The error function from 0 to x.
- NORM.S.DIST: The standard normal distribution (mean 0, standard deviation 1) at a z-score.