NORM.S.INV function
NORM.S.INV converts a probability into the matching z-score on the standard normal curve. It gives the critical value for a confidence level, such as 1.96 for a 95 percent two-sided interval.
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
NORM.S.INV(probability)
-
probability(required) - Cumulative probability, strictly between 0 and 1.
Returns: The z-score with that cumulative probability.
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.S.INV(0.975) | 1.959963985 | Working example |
=NORM.S.INV("0.975") | 1.959963985 | Text-number in first arg |
=NORM.S.INV({0.975,0.975}) | 1.959963985 | Array in first arg (lifts, spills) |
=NORM.S.INV(0.5) | 0 | Probability 0.5 |
=NORM.S.INV("abc") | #VALUE! | Non-numeric text in first arg |
=NORM.S.INV(NA()) | #N/A | Error in first arg |
=NORM.S.INV(0) | #NUM! | Probability 0 |
=NORM.S.INV(1) | #NUM! | Probability 1 |
Watch out for
- For a two-sided 95% interval use 0.975, not 0.95.
- 0 and 1 return #NUM!.
Where it works
- Excel
- NORM.S.INV 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 .