Returns the inverse of the standard normal distribution for the given number.
Sample Usage
NORM.S.INV(.75)
NORM.S.INV(C5)
Syntax
NORM.S.INV(number)
- number - The input to the inverse standard normal distribution function.
Examples
NORM.S.INV(.75) returns a value of 0.6744.
NORM.S.INV(C5) returns the inverse of the standard normal cumulative distribution, with a probability of C5.
Notes
- number must be greater than 0 and less than 1.