NORM.INV Function
Returns the value at a given probability of a normal distribution.
Category
Statistical
Available in
Excel 2010+, Microsoft 365
Returns
A number
Overview
NORM.INV works backwards from NORM.DIST: give it a probability and it returns the value that has that share of the distribution below it.
It answers questions such as "what call length covers 95% of calls?" — useful for service targets, safety stock and simulations (=NORM.INV(RAND(),mean,sd) draws a random bell-curve value).
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| probability | Yes | The share below the value, between 0 and 1 (not including 0 or 1). |
| mean | Yes | The average of the distribution. |
| standard_dev | Yes | The standard deviation; must be greater than 0. |
Examples
Example 1 — A service target that covers 95% of calls
Northstar's support calls average 6 minutes with a standard deviation of 1.5 minutes.
| A | B | |
|---|---|---|
| 1 | Measure | Value |
| 2 | Average (min) | 6 |
| 3 | Std deviation | 1.5 |
| 4 | Share covered | 0.95 |
| 5 | Call length | 8.47 |
| 6 | Shortest 10% | 4.08 |
95% of calls should finish within about 8.5 minutes; the quickest 10% take under about 4.1.
Example 2 — The middle of the curve
A probability of 0.5 always returns the mean.
Returns 6.
Common mistakes
- #NUM! probability is 0 or less, 1 or more, or standard_dev is 0 or negative.
Notes
- NORM.INV replaces the older NORMINV function.
- Related functions: NORM.DIST, NORM.S.INV, PERCENTILE.INC.

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.