Excel functions / Math
ERFC function
The complementary error function: 1 - ERF(x).
Syntax
=ERFC(x)
Arguments
x: Where ERF would stop.
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
At 1
A B C 1 x 2 1 0.15730 In C2:
=ERFC(A2)→ 0.15730
Common mistakes
- Small tails. For large x, ERFC keeps digits that 1-ERF(x) would lose.
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.
- Czech: ERFC
- Danish: FEJLFUNK.KOMP
- Dutch: FOUT.COMPLEMENT
- Finnish: VIRHEFUNKTIO.KOMPLEMENTTI
- French: ERFC
- German: GAUSSFKOMPL
- Hungarian: HIBAF.KOMPLEMENTER
- Italian: FUNZ.ERRORE.COMP
- Norwegian: FEILFK
- Polish: KOMP.FUNKCJA.BŁ
- Portuguese (Brazil): FUNERROCOMPL
- Portuguese (Portugal): FUNCERROCOMPL
- Russian: ДФОШ
- Spanish: FUN.ERROR.COMPL
- Swedish: FELFK
- Turkish: TÜMHATAİŞLEV
Also written as ERFC.PRECISE.
Related functions
- ERF: The error function between two limits. With one limit it runs from 0.
- NORM.S.DIST: The standard normal distribution (mean 0, standard deviation 1) at a z-score.