ERFC function
ERFC returns the complementary error function, which is 1 minus ERF. It stays accurate for large values, where subtracting ERF from 1 would lose precision, and it accepts negative values.
Example
Read it as a sentence: find the complementary error function value for 1, which gives 0.157299207050285.
A
B
C
D
1
0.157299207050285
2
3
Syntax
ERFC(x)
-
x(required) - The lower limit of integration (upper is infinity).
Returns: The complementary error function, 1 minus ERF(x).
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=ERFC(0.5) | 0.479500122 | 0.5 |
=ERFC(0) | 1 | 0 |
=ERFC(-0.5) | 1.520499878 | Negative |
=ERFC(10) | 2.08849E-45 | Large |
=ERFC("0.5") | 0.479500122 | Text number |
=ERFC({0.5,1}) | 0.479500122 | Spill |
=ERFC("a") | #VALUE! | Text |
=ERFC(TRUE) | #VALUE! | TRUE |
Watch out for
- Negative x is allowed.
Where it works
- Excel
- ERFC is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Engineering functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .