SpreadJS 14
Formula Reference / Formula Functions / Statistical Functions / 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