ERF Function
Returns the error function, integrated between two limits.
Category
Engineering
Available in
All versions, Microsoft 365
Returns
A number from −1 to 1
Overview
ERF returns the error function between 0 and lower_limit — or between lower_limit and upper_limit when you give both. The error function erf(x) comes from the normal (bell-curve) distribution: erf(x/√2) is the chance a normally distributed value lands within x standard deviations of the mean.
It's used in statistics, heat transfer and diffusion models.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| lower_limit | Yes | The lower bound (or the only bound, measured from 0). |
| upper_limit | No | The upper bound. When given, ERF returns erf(upper) − erf(lower). |
Examples
Example 1 — Within 1, 2 and 3 standard deviations
The famous 68–95–99.7 rule. Results are rounded to 4 decimal places here.
| A | B | |
|---|---|---|
| 1 | Std devs | Share inside |
| 2 | 1 | 0.6827 |
| 3 | 2 | 0.9545 |
| 4 | 3 | 0.9973 |
Example 2 — Between two limits
With two arguments, ERF returns the difference.
Returns about 0.3222 (0.8427 − 0.5205).
Common mistakes
- #VALUE! A limit is text.
Notes
- ERF accepts negative limits in current Excel versions: ERF(−1) is −0.8427.
- Related functions: ERF.PRECISE, ERFC, NORM.S.DIST.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.