Functions
NORMSINV
Standard normal inverse CDF (legacy)
Try it
When to use it
When should I use NORMSINV?
NORMSINV is the legacy form of NORM.S.INV. Use it only when maintaining older spreadsheets; for new work prefer NORM.S.INV. Both convert a cumulative probability to the corresponding z-score on the standard normal distribution.
Used in
Syntax
NORMSINV(p)Examples
=NORMSINV(0.75) // => 0.6744897502234225