BINOM.DIST function
BINOM.DIST tells you how likely it is to get a set number of successes in a fixed number of yes/no trials, such as defective items in a batch or conversions from sales calls.
Example
Read it as a sentence: find the chance of getting 3 or fewer successes in 10 tries when each try has a 50% chance.
A
B
C
D
1
0.171875
2
3
Syntax
BINOM.DIST(number_s, trials, probability_s, cumulative)
-
number_s(required) - Number of successes.
-
trials(required) - Number of independent trials.
-
probability_s(required) - Chance of success on each trial.
-
cumulative(required) - TRUE for chance of at most number_s successes, FALSE for exactly that many.
Returns: The binomial probability of the given number of successes.
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(3,10,0.5,TRUE) | 0.171875 | Working example |
=BINOM.DIST(3,10,0.5,FALSE) | 0.1171875 | Other cumulative flag |
=BINOM.DIST(3,10,0.5,0) | 0.1171875 | Cumulative as 0 |
=BINOM.DIST("3",10,0.5,TRUE) | 0.171875 | Text-number in first arg |
=BINOM.DIST({3,3},10,0.5,TRUE) | 0.171875 | Array in first arg (lifts, spills) |
=BINOM.DIST(3.7,10,0.5,FALSE) | 0.1171875 | Fractional successes truncated |
=BINOM.DIST("abc",10,0.5,TRUE) | #VALUE! | Non-numeric text in first arg |
=BINOM.DIST(NA(),10,0.5,TRUE) | #N/A | Error in first arg |
Watch out for
- number_s and trials are truncated to whole numbers.
- TRUE gives 'at most', not 'exactly'; people often mix these up.
Where it works
- Excel
- BINOM.DIST arrived in Excel 2010. Older versions do not have it.
- Google Sheets
- Same name, but behaves differently. Google Sheets supports BINOM.DIST and the older BINOMDIST with the same arguments.
Part of Statistical functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .