Wauvel

Excel like a finance pro.

← The library

Statistical function

BINOM.DIST.RANGE

Returns the probability of a trial result falling in a range using the binomial distribution.

Rarely usedDifficulty 1500 · AdvancedUsage rank #383 of 520
Practice · 2 questions →

When to use it

The probability that the number of successes falls between two values, inclusive. Saves adding up several BINOM.DIST calls.

The shape of it

Syntax
=BINOM.DIST.RANGE(trials, probability_s, number_s, [number_s2])

Worked examples

  • One value

    =BINOM.DIST.RANGE(10,0.5,6) → 0.205078125

    Exactly 6 of 10.

  • A range

    =BINOM.DIST.RANGE(10,0.5,4,6) → 0.65625

    4, 5, or 6 heads.

  • Larger trial

    =BINOM.DIST.RANGE(60,0.75,48) → 0.084

    Exactly 48 successes in 60 trials at 75%.

Worth knowing

  • "At least k" is BINOM.DIST.RANGE(n,p,k,n).
  • Equivalent to BINOM.DIST(k2,...,TRUE) - BINOM.DIST(k1-1,...,TRUE).
  • Introduced in Excel 2013.

Where it goes wrong

  • #NUM! when number_s2 is less than number_s or exceeds trials.
  • #NAME? in Excel 2010 and earlier.

Related

AVERAGECOUNTCOUNTACOUNTIFCOUNTIFSMAX

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.