This function returns the inverse of the standard normal cumulative distribution. The distribution has a mean of zero and a standard deviation of one.
NORM.S.INV(prob)
The argument is the probability for the normal distribution.
The #VALUE! error value is returned if any argument is nonnumeric.
Accepts numeric data. Returns numeric data.
NORM.S.INV(A3)
NORM.S.INV(R1C2)
NORM.S.INV(0.9244) gives the result 1.435305714537128