NORM.DIST Function
Returns the normal distribution for a given mean and standard deviation.
Category
Statistical
Available in
Excel 2010+, Microsoft 365
Returns
A number
Overview
NORM.DIST works with the bell curve. Give it a value, the average and the standard deviation, and it tells you how likely it is to get that value or less.
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.
For the probability above a value, use 1 − NORM.DIST(…, TRUE); between two values, subtract one cumulative result from the other.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| x | Yes | The value to evaluate. |
| mean | Yes | The average of the distribution. |
| standard_dev | Yes | The standard deviation; must be greater than 0. |
| cumulative | Yes | TRUE for the cumulative probability, FALSE for the density (height of the curve). |
Examples
Example 1 — How many calls finish within 8 minutes?
Northstar's support calls average 6 minutes with a standard deviation of 1.5 minutes.
| A | B | |
|---|---|---|
| 1 | Measure | Value |
| 2 | Average (min) | 6 |
| 3 | Std deviation | 1.5 |
| 4 | Call length | 8 |
| 5 | P(8 min or less) | 0.9088 |
| 6 | P(more than 8) | 0.0912 |
About 91% of calls finish within 8 minutes, so roughly 9% run longer.
Example 2 — Between two values
The share of calls lasting 5 to 7 minutes.
Returns about 0.495 — just under half.
Example 3 — Height of the curve
With FALSE, NORM.DIST returns the density, used for drawing the bell curve on a chart.
Returns about 0.1093.
Common mistakes
- Forgetting cumulative. The last argument has no default. TRUE is almost always what you want for a probability.
- #NUM! standard_dev is 0 or negative.
- Not every dataset is bell-shaped. Skewed data (such as order values or wait times) can give misleading results. Check a histogram first.
Notes
- NORM.DIST replaces the older NORMDIST function.
- Related functions: NORM.INV, NORM.S.DIST, STANDARDIZE, LOGNORM.DIST.

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.