STANDARDIZE Function
Returns a z-score: how many standard deviations a value is from the mean.
Category
Statistical
Available in
All versions, Microsoft 365
Returns
A number
Overview
STANDARDIZE calculates (x − mean) ÷ standard deviation. The result, a z-score, puts values measured on different scales onto one common scale.
0 means exactly average, +1 means one standard deviation above, −2 two below. In bell-shaped data, about 95% of values fall between −2 and +2.
You supply the mean and standard deviation yourself — usually with AVERAGE and STDEV.S.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| x | Yes | The value to standardize. |
| mean | Yes | The average of the data. |
| standard_dev | Yes | The standard deviation of the data; must be greater than 0. |
Examples
Example 1 — A z-score for every rep
Lock the mean and standard deviation ranges with $ so the formula fills down.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Rep | Region | Sales | z-score |
| 2 | Ana | North | 62000 | 0.81 |
| 3 | Ben | South | 48500 | -0.50 |
| 4 | Cy | North | 50000 | -0.35 |
| 5 | Di | East | 71250 | 1.70 |
| 6 | Ed | South | 39800 | -1.34 |
| 7 | Fay | North | 55400 | 0.17 |
| 8 | Gus | East | 48500 | -0.50 |
Di is 1.7 standard deviations above average; Ed is 1.34 below. Nobody is beyond ±2.
Example 2 — Comparing different scales
A 78 on a test with mean 70 and standard deviation 4 beats an 85 on a test with mean 80 and standard deviation 10.
Returns 2, while =STANDARDIZE(85,80,10) returns only 0.5.
Common mistakes
- #NUM! standard_dev is 0 or negative.
- Relative ranges. Without $ signs, the mean and standard deviation ranges shift as you fill down and every z-score is wrong.
Notes
- To turn a z-score into a probability, use NORM.S.DIST.
- Related functions: AVERAGE, STDEV.S, NORM.S.DIST, PERCENTRANK.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.