BINOMDIST function
BINOMDIST tells you how likely a set number of successes is across repeated yes/no trials, such as defects in a batch. It is a compatibility function; use BINOM.DIST in new workbooks.
Example
Read it as a sentence: find the chance of exactly the number of successes in D1 (empty, so 0) in 4 tries when each try has a 50% chance, which gives 0.0625.
Excel shows 0.0625
D
1
Data
Syntax
BINOMDIST(number_s, trials, probability_s, cumulative)
-
number_s(required) - Number of successes you are asking about.
-
trials(required) - Number of independent attempts.
-
probability_s(required) - Chance of success on each attempt.
-
cumulative(required) - TRUE for at-most-this-many successes, FALSE for exactly this many.
Returns: A binomial probability.
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 |
|---|---|---|
=BINOMDIST(2,4,0.5,FALSE) | 0.375 | Working example |
=BINOMDIST(2,4,0.5,TRUE) | 0.6875 | Other cumulative flag |
=BINOMDIST(2,4,0.5,0) | 0.375 | Cumulative as 0 |
=BINOMDIST("2",4,0.5,FALSE) | 0.375 | Text-number in first arg |
=BINOMDIST({2,2},4,0.5,FALSE) | 0.375 | Array in first arg (lifts, spills) |
=BINOMDIST(Data!D1,4,0.5,FALSE) | 0.0625 | Blank cell as first arg |
=BINOMDIST("abc",4,0.5,FALSE) | #VALUE! | Non-numeric text in first arg |
=BINOMDIST(NA(),4,0.5,FALSE) | #N/A | Error in first arg |
The Data sheet these formulas read
A cell that starts with = holds that formula.
D
1
Data
Watch out for
- Superseded by BINOM.DIST; use that in new workbooks.
- Mixing up cumulative TRUE/FALSE is the usual mistake: TRUE adds up everything from 0 to number_s.
Where it works
- Excel
- BINOMDIST is in every version of Excel from 2007 on. Compatibility function: still works in every version, but newer replacements exist.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Compatibility functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .