Excel like a finance pro.
← The libraryPractice · 2 questions →
Engineering function
ERFC.PRECISE
Returns the complementary error function with improved precision.
Rarely usedDifficulty 1500 · AdvancedUsage rank #490 of 520
When to use it
The complementary error function with full precision, including negative inputs.
The shape of it
- Syntax
=ERFC.PRECISE(x)
Worked examples
One
=ERFC.PRECISE(1) → 0.157299207
At 1.
Half
=ERFC.PRECISE(0.5) → 0.479500122
At 0.5.
Negative
=ERFC.PRECISE(-1) → 1.842700793
Above 1 for negative inputs.
Worth knowing
- Bit error rate formulas use 0.5*ERFC.PRECISE(SQRT(snr)).
- Same as 1 - ERF.PRECISE(x).
- Introduced in Excel 2010.
Where it goes wrong
- #VALUE! for text.
- Underflows to 0 for x above about 27.
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.