Excel like a finance pro.
← The libraryPractice · 2 questions →
Engineering function
ERF
Returns the error function.
Rarely usedDifficulty 1500 · AdvancedUsage rank #487 of 520
When to use it
The error function, integrated from 0 to the limit, or between two limits. Related to the normal distribution.
The shape of it
- Syntax
=ERF(lower_limit, [upper_limit])
Worked examples
One limit
=ERF(0.5) → 0.520499878
From 0 to 0.5.
One
=ERF(1) → 0.842700793
From 0 to 1.
Two limits
=ERF(0,1) → 0.842700793
Between two limits.
Worth knowing
- Normal CDF: 0.5*(1+ERF(z/SQRT(2))).
- ERF.PRECISE is the same to more precision.
- ERFC is 1 - ERF.
Where it goes wrong
- Negative lower limits returned #NUM! before Excel 2010.
- Text arguments return #VALUE!.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.