Related Function:

The BINOM.DIST.RANGE function returns the binomial distribution probability for the number of successes from a specified number of trials falling into a specified range.

• This function was introduced in Excel 2013 and so is not available in earlier versions.

### Syntax

=BINOM.DIST.RANGE(trials,probability_s,number_s,[number_s2])

#### Arguments

Argument Description
trials The number of independent trials that are to be done – must be ≥ 0
probability_s The probability of success in each trial – must be ≥ 0 and ≤ 1
number_s The number of successes in trials – must be ≥ 0 and ≤ trials
Optional. the maximum number of successes that you want to calculate the probability for

 • If provided, [number_s2] must be ≥ number_s and ≤ trials • If the [number_s2] argument is omitted, the function calculates the probability of exactly number_s successes

#### Examples

A B C
1 Formula Result Notes
2 =BINOM.DIST.RANGE(60,0.75,48) 0.084 Returns the binomial distribution based on the probability of 48 successes in 60 trials and a 75% probability of success (84%)
3 =BINOM.DIST.RANGE(60,0.75,45,50) 0.524 Returns the binomial distribution based on the probability of between 45 and 50 successes (inclusive) in 60 trials and a 75% probability of success (52.4%)

#### Common Function Error(s)

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

 • the supplied probability_s is < 0 or > 1 • the supplied number_s is < 0 or > trials • the supplied [number_s2] is < 0 or > trials or < number_s

The following equation is used to calculate binomial distribution: