Returns the inverse of the standard normal distribution for the given number.
Sample Usage
NORMSINV(.75)
NORMSINV(C5)
Syntax
NORMSINV(number)
- number - The input to the inverse standard normal distribution function.
- value2, .. - [OPTIONAL] Additional numbers or ranges to consider.
Examples
NORMSINV(.75) returns a value of 0.6744.
NORMSINV(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.