BINOM.DIST.RANGE function
BINOM.DIST.RANGE gives the chance that the number of successes in a set of yes/no trials falls between two values, inclusive. It saves subtracting two cumulative BINOM.DIST results by hand.
Example
Read it as a sentence: find the chance of getting between 3 and 5 successes in 10 tries when each try has a 50% chance.
A
B
C
D
1
0.568359375
2
3
Syntax
BINOM.DIST.RANGE(trials, probability_s, number_s, [number_s2])
Arguments in [square brackets] are optional.
-
trials(required) - Number of independent trials.
-
probability_s(required) - Chance of success on each trial.
-
number_s(required) - Lower number of successes.
-
number_s2(optional) - Upper number of successes; if omitted, only number_s exactly.
Returns: The probability of a success count falling within the given range.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=BINOM.DIST.RANGE(10,0.5,3,5) | 0.568359375 | Working example |
=BINOM.DIST.RANGE("10",0.5,3,5) | 0.568359375 | Text-number in first arg |
=BINOM.DIST.RANGE({10,10},0.5,3,5) | 0.568359375 | Array in first arg (lifts, spills) |
=BINOM.DIST.RANGE(10,0.5,3) | 0.1171875 | Single number_s |
=BINOM.DIST.RANGE("abc",0.5,3,5) | #VALUE! | Non-numeric text in first arg |
=BINOM.DIST.RANGE(NA(),0.5,3,5) | #N/A | Error in first arg |
=BINOM.DIST.RANGE(10,0.5,5,3) | #NUM! | number_s2 < number_s |
=BINOM.DIST.RANGE(10,1.2,3) | #NUM! | Probability > 1 |
Watch out for
- Both ends of the range are inclusive.
- Leaving number_s2 out gives the exact-count probability.
Where it works
- Excel
- BINOM.DIST.RANGE arrived in Excel 2013. Older versions do not have it.
- Google Sheets
- No direct equivalent. No built-in counterpart; subtract two BINOM.DIST cumulative results instead.
Part of Statistical functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .