NORMDIST function
NORMDIST gives the probability of landing at or below a value on a bell curve, such as the share of test scores under a cutoff. It is a compatibility function; NORM.DIST replaces it in new workbooks.
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
NORMDIST(x, mean, standard_dev, cumulative)
-
x(required) - Value to evaluate.
-
mean(required) - Mean of the distribution.
-
standard_dev(required) - Standard deviation, above 0.
-
cumulative(required) - TRUE for the cumulative probability, FALSE for the bell-curve height.
Returns: A normal-distribution value.
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 |
|---|---|---|
=NORMDIST(42,40,1.5,TRUE) | 0.90878878 | Working example |
=NORMDIST(42,40,1.5,FALSE) | 0.10934005 | Other cumulative flag |
=NORMDIST(42,40,1.5,0) | 0.10934005 | Cumulative as 0 |
=NORMDIST("42",40,1.5,TRUE) | 0.90878878 | Text-number in first arg |
=NORMDIST({42,42},40,1.5,TRUE) | 0.90878878 | Array in first arg (lifts, spills) |
=NORMDIST(Data!D1,40,1.5,TRUE) | 5.7348E-157 | Blank cell as first arg |
=NORMDIST("abc",40,1.5,TRUE) | #VALUE! | Non-numeric text in first arg |
=NORMDIST(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
- Superseded by NORM.DIST; use that in new workbooks.
- FALSE returns a density, not a probability of that exact value.
Where it works
- Excel
- NORMDIST is in every version of Excel from 2007 on. Compatibility function: still works in every version, but newer replacements exist.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Compatibility functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .