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

Want to practice BINOM.DIST in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

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

=BINOM.DIST(number_s, trials, probability_s, cumulative) Explain

Arguments

ArgumentRequired?What it does
number_sYesThe number of successes (decimals are truncated).
trialsYesThe number of independent tries.
probability_sYesThe chance of success on each try, from 0 to 1.
cumulativeYesTRUE 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.

B2fx=BINOM.DIST(A2,20,0.15,FALSE)
ABC
1SalesExactlyAt most
200.03880.0388
310.13680.1756
420.22930.4049
530.24280.6477
640.18210.8298
750.10280.9327
860.04540.9781
=BINOM.DIST(A2,20,0.15,FALSE) Explain

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.

=1-BINOM.DIST(4,20,0.15,TRUE) Explain

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

Kyle Stott

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.