NORMSDIST function
NORMSDIST converts a z-score into the share of values at or below it on the standard normal curve. It is a compatibility function; NORM.S.DIST replaces it in new workbooks.
Example
Read it as a sentence: find the cumulative chance of a standard normal value at or below the number in D1, which gives 0.5.
Excel shows 0.5
D
1
Data
Syntax
NORMSDIST(z)
-
z(required) - A z-score.
Returns: Cumulative probability under the standard normal curve.
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 |
|---|---|---|
=NORMSDIST(1.96) | 0.975002105 | Working example |
=NORMSDIST("1.96") | 0.975002105 | Text-number in first arg |
=NORMSDIST({1.96,1.96}) | 0.975002105 | Array in first arg (lifts, spills) |
=NORMSDIST(0) | 0.5 | Zero |
=NORMSDIST(40) | 1 | Large z |
=NORMSDIST(Data!D1) | 0.5 | Blank cell as first arg |
=NORMSDIST("abc") | #VALUE! | Non-numeric text in first arg |
=NORMSDIST(NA()) | #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.S.DIST; use that in new workbooks.
- Always cumulative; NORM.S.DIST adds a cumulative switch.
Where it works
- Excel
- NORMSDIST 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 .