Excel like a finance pro.
← The libraryPractice · 3 questions →
Compatibility function
NORMDIST
Returns the normal distribution; replaced by NORM.DIST.
OccasionalDifficulty 1350 · AdvancedUsage rank #221 of 520
When to use it
The normal distribution. Replaced by NORM.DIST with identical arguments.
The shape of it
- Syntax
=NORMDIST(x, mean, standard_dev, cumulative)
Worked examples
Standard normal
=NORMDIST(1.96,0,1,TRUE) → 0.975002105
Standard normal.
Cumulative
=NORMDIST(42,40,1.5,TRUE) → 0.908789
Mean 40, sd 1.5.
Density
=NORMDIST(42,40,1.5,FALSE) → 0.10934
Density.
Worth knowing
- NORM.DIST is identical.
- Cumulative TRUE for probabilities.
- NORMINV reverses it.
Where it goes wrong
- #NUM! for a non-positive sd.
- Flagged by the Compatibility Checker.
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.