Spread Formula Reference
Formula Functions / Functions M to Q / NORM.INV
In This Topic
    NORM.INV
    In This Topic

    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

    Version Available

    This function is available in Spread for Windows Forms 11.0 or later.

    See Also

    NORMINV