In this article
ERF.PRECISE is the 2010 version of ERF with one argument.
Advertisement
Syntax
=ERF.PRECISE(x)| Argument | What it means |
|---|---|
x |
Value |
Examples
Example 1
=ROUND(ERF.PRECISE(A2),5)Result: 0.5205. See the worked example table below for more cases.
ERF.PRECISE in practice
Where you will use it
- Probability of measurement errors within limits
- Diffusion and heat equations
- Signal processing
Worked example
| x | Formula | Result |
|---|---|---|
| 0.5 | =ROUND(ERF.PRECISE(A2),5) | 0.5205 |
| 1 | =ROUND(ERF.PRECISE(A3),5) | 0.8427 |
| 2 | =ROUND(ERF.PRECISE(A4),5) | 0.99532 |
Results calculated in Excel.
Mistakes people make
| Mistake | What to do instead |
|---|---|
| Confusing with NORM.S.DIST | ERF(x/SQRT(2)) = 2*NORM.S.DIST(x)-1 |
| Negative x in old ERF | Older versions gave #NUM!; ERF.PRECISE accepts negatives |
Related functions
ERF · ERFC · NORM.S.DIST
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
✨ Ask AI about this article
Stuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong