NORM.S.DIST Function
Returns the standard normal distribution (mean 0, standard deviation 1).
Category
Statistical
Available in
Excel 2010+, Microsoft 365
Returns
A number
Overview
NORM.S.DIST is NORM.DIST for z-scores: the bell curve with mean 0 and standard deviation 1. Turn any value into a z-score with STANDARDIZE, then look up its probability here.
TRUE returns the cumulative probability (the chance of a value up to x); FALSE returns the probability density — the height of the curve, not a probability.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| z | Yes | The z-score. |
| cumulative | Yes | TRUE for the cumulative probability, FALSE for the density (height of the curve). |
Examples
Example 1 — What share falls below a z-score?
A z-score of 1.5 means 1.5 standard deviations above the mean.
| A | B | |
|---|---|---|
| 1 | Measure | Value |
| 2 | z-score | 1.5 |
| 3 | Share below | 0.9332 |
| 4 | Share above | 0.0668 |
About 93% of values are below z = 1.5, and about 7% above.
Example 2 — The familiar 2.5%
The share of values more than 1.96 standard deviations below the mean.
Returns about 0.025 — the lower tail of a 95% interval.
Common mistakes
- Forgetting cumulative. Use TRUE for a probability; FALSE gives the height of the curve (PHI).
Notes
- Related functions: NORM.S.INV, NORM.DIST, STANDARDIZE, GAUSS, PHI.

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.