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

ArgumentRequired?What it does
trialsYesThe number of independent tries.
probability_sYesThe chance of success on each try.
number_sYesThe lowest number of successes.
number_s2NoThe 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)
AB
1MeasureValue
2Calls20
3Close rate0.15
42 to 4 sales0.6543
55 or more0.1702
6Exactly 30.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

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.