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

Want to practice ERF in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

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

=ERF(lower_limit, [upper_limit])

Arguments

ArgumentRequired?What it does
lower_limitYesThe lower bound (or the only bound, measured from 0).
upper_limitNoThe 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.

B2fx=ERF(A2/SQRT(2))
AB
1Std devsShare inside
210.6827
320.9545
430.9973
=ERF(A2/SQRT(2)) Explain

Example 2 — Between two limits

With two arguments, ERF returns the difference.

=ERF(0.5,1) Explain

Returns about 0.3222 (0.8427 − 0.5205).

Common mistakes

  • #VALUE! A limit is text.

Notes

Kyle Stott

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.