NORM.S.INV FunctionWayne Becker
The NORM.S.INV function returns the inverse of the standard normal cumulative distribution. The distribution has a mean of zero and a standard deviation of one.
- This function was introduced in Excel 2010 and so is not available in earlier versions.
- The NORM.S.INV function replaces the NORMSINV function included in earlier versions of Excel.
||A probability value, between 0 and 1, at which you want to calculate the inverse of the standard normal cumulative distribution function
||Inverse of the standard normal cumulative distribution, with a probability of 0.933193
Common Function Error(s)
||What went wrong
||Occurs if the supplied probability argument is non-numeric
||Occurs if the supplied probability argument is ≤ 0 or ≥ 1