Spread.Sheets Documentation
NORM.INV
Spread.Sheets Documentation > Formula Reference > Formula Functions > NORM.INV

This function returns the inverse of the normal cumulative distribution for the given mean and standard deviation.

Syntax

NORM.INV(prob,mean,stdev)

Arguments

This function has these arguments:

Argument Description
prob Probability of the normal distribution
mean Arithmetic mean of the distribution
stdestdev Standard deviation of the distribution; must be greater than zero

Remarks

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

Data Types

Accepts numeric data for all arguments. Returns numeric data.

Examples

NORM.INV(B3,C12,D14)

NORM.INV(R3C2,R12C3,R14C4)

NORM.INV(0.978,32,0.252) gives the result 32.50755088397007