Excel like a finance pro.
← The libraryPractice · 2 questions →
Compatibility function
NORMSDIST
Returns the standard normal cumulative distribution; replaced by NORM.S.DIST.
OccasionalDifficulty 1350 · AdvancedUsage rank #223 of 520
When to use it
The standard normal cumulative distribution. Replaced by NORM.S.DIST, which adds a cumulative flag.
The shape of it
- Syntax
=NORMSDIST(z)
Worked examples
Cumulative
=NORMSDIST(1.96) → 0.975002105
The 97.5% point.
Another z
=NORMSDIST(1.333333) → 0.908788726
Another z.
Median
=NORMSDIST(0) → 0.5
The median.
Worth knowing
- NORM.S.DIST(z,TRUE) is identical.
- No density option here.
- Two-tailed p: 2*(1-NORMSDIST(ABS(z))).
Where it goes wrong
- #VALUE! for text.
- 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.