The Excel BINOM.DIST.RANGE function returns the probability of a number of successes falling within a range — for example, between 4 and 6 successes in 10 trials — in a single formula.
Syntax
| Argument | Description | |
|---|---|---|
trials | Required | The total number of independent trials. |
probability_s | Required | The probability of success on a single trial (0 to 1). |
number_s | Required | The lower bound for the number of successes. |
number_s2 | Optional | The upper bound. If omitted, the function returns the probability of exactly number_s. |
How to use it
BINOM.DIST.RANGE saves you from subtracting two cumulative binomial values by hand. Give it a lower count (number_s) and an upper count (number_s2), and it returns the total probability of landing anywhere in that inclusive range.
Leave out number_s2 and the function behaves like BINOM.DIST(...,FALSE), returning the probability of exactly number_s successes.
Equivalent shortcut: =BINOM.DIST.RANGE(n,p,a,b) equals BINOM.DIST(b,n,p,TRUE) - BINOM.DIST(a-1,n,p,TRUE), but in one tidy call.
Try it: interactive demo
Pick a BINOM.DIST.RANGE example to see the formula and its result.
Practice workbook
Frequently asked questions
What happens if I omit number_s2?
number_s successes — identical to BINOM.DIST(number_s, trials, probability_s, FALSE).Is the range inclusive of both endpoints?
BINOM.DIST.RANGE(10,0.5,4,6) includes 4, 5, and 6 successes in the total.How does it relate to BINOM.DIST?
BINOM.DIST(b,n,p,TRUE)-BINOM.DIST(a-1,n,p,TRUE).Which Excel versions have BINOM.DIST.RANGE?
Master functions like this in one day
This page covers one function. Our Excel Formulas and Functions class covers the 30 that matter most — live, hands-on, taught by professionals in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class