NORMSINV function
NORMSINV returns the z-score that cuts off a given lower-tail probability on the standard normal curve. It is a compatibility function; NORM.S.INV replaces it in new workbooks.
Example
Read it as a sentence: find the standard normal value with 0.975 of the distribution at or below it, which gives 1.959963985.
A
B
C
D
1
1.959963985
2
3
Syntax
NORMSINV(probability)
-
probability(required) - Cumulative probability between 0 and 1.
Returns: The z-score at that percentile.
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 |
|---|---|---|
=NORMSINV(0.975) | 1.959963985 | Working example |
=NORMSINV("0.975") | 1.959963985 | Text-number in first arg |
=NORMSINV({0.975,0.975}) | 1.959963985 | Array in first arg (lifts, spills) |
=NORMSINV(0.5) | 0 | Probability 0.5 |
=NORMSINV("abc") | #VALUE! | Non-numeric text in first arg |
=NORMSINV(NA()) | #N/A | Error in first arg |
=NORMSINV(0) | #NUM! | Probability 0 |
=NORMSINV(1) | #NUM! | Probability 1 |
Watch out for
- Superseded by NORM.S.INV; use that in new workbooks.
Where it works
- Excel
- NORMSINV 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 .