BINOM.DIST Function
Returns the binomial probability of a number of successes in a fixed number of tries.
Category
Statistical
Available in
Excel 2010+, Microsoft 365
Returns
A number
Overview
BINOM.DIST answers "what's the chance of exactly (or at most) k successes in n independent tries, each with the same chance of success?" — sales calls that close, parcels that arrive late, emails that get opened.
With cumulative FALSE it returns the chance of exactly number_s successes; with TRUE, of at most number_s.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| number_s | Yes | The number of successes (decimals are truncated). |
| trials | Yes | The number of independent tries. |
| probability_s | Yes | The chance of success on each try, from 0 to 1. |
| cumulative | Yes | TRUE for the chance of at most this many; FALSE for exactly this many. |
Examples
Example 1 — Sales from 20 calls
Each call has a 15% chance of closing. Column B is filled down from B2; C shows the running total.
| A | B | C | |
|---|---|---|---|
| 1 | Sales | Exactly | At most |
| 2 | 0 | 0.0388 | 0.0388 |
| 3 | 1 | 0.1368 | 0.1756 |
| 4 | 2 | 0.2293 | 0.4049 |
| 5 | 3 | 0.2428 | 0.6477 |
| 6 | 4 | 0.1821 | 0.8298 |
| 7 | 5 | 0.1028 | 0.9327 |
| 8 | 6 | 0.0454 | 0.9781 |
3 sales is the most likely result (24%), and there's about a 4% chance of none at all.
Example 2 — Five or more sales
Subtract "at most 4" from 1.
Returns about 0.17.
Common mistakes
- #NUM! number_s is negative or more than trials, or probability_s is below 0 or above 1.
- "At least" questions. At least k = 1 − BINOM.DIST(k − 1, …, TRUE). BINOM.DIST.RANGE does it in one step.
Notes
- BINOM.DIST replaces the older BINOMDIST function.
- Related functions: BINOM.DIST.RANGE, BINOM.INV, NEGBINOM.DIST, HYPGEOM.DIST, POISSON.DIST.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.