Excel functions / Statistics

BINOM.DIST.RANGE function

The chance that the number of successes in a set of tries lands between two counts.

Syntax

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

Arguments

When to use it

BINOM.DIST.RANGE gives the chance that the number of successes in a set of tries lands between two counts.

Examples

  1. 45 to 50 successes in 60 tries at 75%

    ABCD
    1TriesChance
    2600.750.524

    In D2: =BINOM.DIST.RANGE(A2, B2, 45, 50) → 0.524

    Try this example

Common mistakes

BINOM.DIST.RANGE in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try BINOM.DIST.RANGE in the playground

Related functions