This function returns the inverse of the standard normal cumulative distribution. The distribution has a mean of zero and a standard deviation of one.

Syntax

NORM.S.INV(prob)

Arguments

The argument is the probability for the normal distribution.

Remarks

The #VALUE! error value is returned if any argument is nonnumeric.

Data Types

Accepts numeric data. Returns numeric data.

Examples

NORM.S.INV(A3)

NORM.S.INV(R1C2)

NORM.S.INV(0.9244) gives the result 1.435305714537128