NORM.S.INV Function
Returns the z-score at a given probability of the standard normal distribution.
Category
Statistical
Available in
Excel 2010+, Microsoft 365
Returns
A number
Overview
NORM.S.INV is the reverse of NORM.S.DIST: give it a probability and it returns the z-score with that share below it.
It's how the well-known critical values are found: 1.645 for 90% two-sided (95% one-sided) confidence, 1.96 for 95% and 2.576 for 99%.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| probability | Yes | The share below the z-score, between 0 and 1 (not including 0 or 1). |
Examples
Example 1 — Critical value for 95% confidence
A two-sided 95% interval leaves 2.5% in each tail, so look up 0.975.
| A | B | |
|---|---|---|
| 1 | Measure | Value |
| 2 | Confidence | 0.95 |
| 3 | z | 1.96 |
Returns 1.95996, usually rounded to 1.96.
Example 2 — One-sided 95%
For a one-tailed test, all 5% sits in one tail.
Returns about 1.645.
Common mistakes
- #NUM! probability is 0 or less, or 1 or more.
Notes
- Related functions: NORM.S.DIST, NORM.INV, CONFIDENCE.NORM.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.