In this article
ERFC.PRECISE is the 2010 version of ERFC.
Advertisement
Syntax
=ERFC.PRECISE(x)| Argument | What it means |
|---|---|
x |
Value |
Examples
Example 1
=ROUND(ERFC.PRECISE(A2),5)Result: 0.4795. See the worked example table below for more cases.
ERFC.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(ERFC.PRECISE(A2),5) | 0.4795 |
| 1 | =ROUND(ERFC.PRECISE(A3),5) | 0.1573 |
| 2 | =ROUND(ERFC.PRECISE(A4),5) | 0.00468 |
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