BINOM.DIST.RANGE Function
Returns the probability of a number of successes falling within a range.
Category
Statistical
Available in
Excel 2013+, Microsoft 365
Returns
A number
Want to practice BINOM.DIST.RANGE 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.RANGE returns the chance that the number of successes in n tries lands between number_s and number_s2 (inclusive). Leave number_s2 out for the chance of exactly number_s.
It saves subtracting two cumulative BINOM.DIST results.
Syntax
=BINOM.DIST.RANGE(trials, probability_s, number_s, [number_s2])
Arguments
| Argument | Required? | What it does |
|---|---|---|
| trials | Yes | The number of independent tries. |
| probability_s | Yes | The chance of success on each try. |
| number_s | Yes | The lowest number of successes. |
| number_s2 | No | The highest number of successes; if left out, exactly number_s. |
Examples
Example 1 — Two to four sales from 20 calls
Each call has a 15% chance of closing.
B4fx=BINOM.DIST.RANGE(B2,B3,2,4)
| A | B | |
|---|---|---|
| 1 | Measure | Value |
| 2 | Calls | 20 |
| 3 | Close rate | 0.15 |
| 4 | 2 to 4 sales | 0.6543 |
| 5 | 5 or more | 0.1702 |
| 6 | Exactly 3 | 0.2428 |
=BINOM.DIST.RANGE(B2,B3,2,4) Explain
About a 65% chance of 2–4 sales. Using trials as the upper limit gives "5 or more".
Common mistakes
- Argument order. trials and probability come first here — unlike BINOM.DIST, where the number of successes comes first.
- #NUM! number_s is negative or more than trials, number_s2 is below number_s or above trials, or probability_s is outside 0–1.
Notes
- Related functions: BINOM.DIST, BINOM.INV.

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.