Related Functions:

The BINOM.INV function returns the inverse of the cumulative binomial distribution, i.e. for a given number of independent trials, the function returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.

• This function was introduced in Excel 2010 and so is not available in earlier versions.
• BINOM.INV replaces the CRITBINOM function included in earlier versions of Excel.

### Syntax

=BINOM.INV(trials,probability_s,alpha)

#### Arguments

Argument Description
trials The number of independent trials to be done
probability_s The probability of a success on each trial
alpha The criterion value – must be between 0 and 1

#### Examples

A B C C
1 Data
2 100 Number of Bernoulli trials
3 0.5 Probability of a success on each trial
4 0.75 Criterion value
5
6 Formula Result Notes
7 =BINOM.INV(A2,A3,A4) 53 Smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value
8 =BINOM.INV(100,50%,20%) 46
9 =BINOM.INV(100,50%,50%) 50

#### Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if any of the supplied arguments are nonnumeric
#NUM! Occurs if either:

 • the supplied trials argument is < 0 • the supplied probability_s argument is < 0 or > 1 • the supplied alpha argument is < 0 or > 1

The Cumulative Binomial Distribution, calculated by the BINOM.DIST function, is a statistical measure that is frequently used to indicate the probability of obtaining a specific number of successes from a specific number of independent trials.

The BINOM.INV function calculates the inverse of the cumulative binomial distribution, i.e. for a given number of independent trials, the BINOM.INV function returns the smallest value of x, the number of successes, for a specified cumulative binomial distribution probability.