Spread Formula Reference
Formula Functions / Functions A to C / BINOM.INV
In This Topic
    BINOM.INV
    In This Topic

    This function returns the criterion binomial, the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.

    Syntax

    BINOM.INV(n,p,alpha)

    Arguments

    This function has these arguments:

    Argument Description
    n Number of trials; if not an integer, the number is truncated
    p Probability of success on each trial; number between 0 and 1
    alpha Alpha, value for the criterion

    Data Types

    Accepts numeric data for all arguments. Returns numeric data.

    Examples

    BINOM.INV(B5,0.75,0.92)

    BINOM.INV(R5C2,R8C14,0.75)

    BINOM.INV(14,0.75,0.85) gives the result 14

    Version Available

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

    See Also

    BINOMDIST