NORM.S.INV (Probability) NORM.S.INV (Probability)
Probability
Number Number
A probability associated with the distribution, which must be strictly between 0 and 1.
Returns
Number Number
The z-score at which the cumulative standard normal distribution equals the given probability.
Returns the inverse of the cumulative NORM.S.DIST function. Given a probability, this function returns the z-score at which the cumulative standard normal distribution equals that probability. This is equivalent to NORM.INV with a mean of 0 and a standard deviation of 1.
Example
NORM.S.INV (0.7)
NORM.S.INV (0,7)
Returns roughly 0.5.