NORM.DIST function
NORM.DIST returns how likely a value is under a bell curve with a mean and spread you supply. For example, it gives the share of test scores below 42 when the mean is 40.
Example
Read it as a sentence: find the cumulative chance that a normal value with mean 40 and standard deviation 1.5 is at or below the number in D1, which gives 5.7348E-157.
Excel shows 5.7348E-157
D
1
Data
Syntax
NORM.DIST(x, mean, standard_dev, cumulative)
-
x(required) - The value to evaluate.
-
mean(required) - Average of the distribution.
-
standard_dev(required) - Spread of the distribution; must be positive.
-
cumulative(required) - TRUE for the chance of a value at or below x, FALSE for the bell-curve height at x.
Returns: The normal distribution probability or density at x.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=NORM.DIST(42,40,1.5,TRUE) | 0.90878878 | Working example |
=NORM.DIST(42,40,1.5,FALSE) | 0.10934005 | Other cumulative flag |
=NORM.DIST(42,40,1.5,0) | 0.10934005 | Cumulative as 0 |
=NORM.DIST("42",40,1.5,TRUE) | 0.90878878 | Text-number in first arg |
=NORM.DIST({42,42},40,1.5,TRUE) | 0.90878878 | Array in first arg (lifts, spills) |
=NORM.DIST(Data!D1,40,1.5,TRUE) | 5.7348E-157 | Blank cell as first arg |
=NORM.DIST("abc",40,1.5,TRUE) | #VALUE! | Non-numeric text in first arg |
=NORM.DIST(NA(),40,1.5,TRUE) | #N/A | Error in first arg |
The Data sheet these formulas read
A cell that starts with = holds that formula.
D
1
Data
Watch out for
- Use TRUE for probabilities; FALSE rarely answers a business question.
- standard_dev of 0 or less gives #NUM!.
Where it works
- Excel
- NORM.DIST arrived in Excel 2010. Older versions do not have it.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Statistical functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .