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

    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

    Version Available

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

    See Also

    NORMSDIST