ERF.PRECISE function
ERF.PRECISE returns the error function integrated from 0 to a single value. It is a one-argument version of ERF with improved accuracy and does not accept a lower limit.
Example
Read it as a sentence: find the error function value for 1, which gives 0.842700792949715.
A
B
C
D
1
0.842700792949715
2
3
Syntax
ERF.PRECISE(x)
-
x(required) - The upper limit of integration (lower is 0).
Returns: The error function integrated from 0 to 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 |
|---|---|---|
=ERF.PRECISE(0.5) | 0.520499878 | 0.5 |
=ERF.PRECISE(0) | 0 | 0 |
=ERF.PRECISE(-0.5) | -0.520499878 | Negative |
=ERF.PRECISE(10) | 1 | Large |
=ERF.PRECISE("0.5") | 0.520499878 | Text number |
=ERF.PRECISE({0.5,1}) | 0.520499878 | Spill |
=ERF.PRECISE("a") | #VALUE! | Text |
=ERF.PRECISE(TRUE) | #VALUE! | TRUE |
Watch out for
- Does not accept a lower limit; use ERF for that.
Where it works
- Excel
- ERF.PRECISE arrived in Excel 2010. Older versions do not have it.
- 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 .