Functions
NORM.S.INV
Standard normal inverse CDF
Try it
When to use it
When should I use NORM.S.INV?
Use NORM.S.INV to convert a cumulative probability to a z-score — the inverse of NORM.S.DIST. This is essential when building confidence intervals or hypothesis tests where you need a critical z-value for a given significance level.
Used in
Syntax
NORM.S.INV(p)Examples
=NORM.S.INV(0.75) // => 0.6744897502234225