Express how many standard deviations a value sits from the mean.
Copy this formula
=(A2-AVERAGE($A$2:$A$100))/STDEV.S($A$2:$A$100)Subtract the mean from the value and divide by the standard deviation. A z-score of 0 is average, +2 is two deviations above, −1 is one below. Lock the range with absolute references so it stays fixed as you fill down.
=(85-70)/12→1.2585 is 1.25 SD above a mean of 70.
Yes — STANDARDIZE(x, mean, sd) returns the z-score directly.
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.