The BINOM.DIST.RANGE formula calculates the probability of achieving a specified range of successes in a fixed number of trials, each with the same probability of success, using the binomial distribution.

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

- trials - The number of independent trials.
- probability_s - The probability of success on each trial.
- number_s - The lower bound for the number of successes in the range.
- number_s2 - [OPTIONAL] The upper bound for the number of successes in the range. If omitted, the function calculates the probability of exactly "number_s" successes.

`=BINOM.DIST.RANGE(10, 0.5, 3)`

This formula calculates the probability of getting exactly 3 successes in 10 independent trials, each with a 50% probability of success (e.g., getting 3 heads in 10 coin flips). The result is the probability of this specific outcome.

`=BINOM.DIST.RANGE(10, 0.5, 3, 5)`

This formula calculates the probability of getting between 3 and 5 successes (inclusive) in 10 independent trials, each with a 50% probability of success (e.g., getting 3, 4, or 5 heads in 10 coin flips). The result is the cumulative probability of getting 3, 4, or 5 successes.

The BINOM.DIST.RANGE function calculates the probability of a range of successes in a fixed number of trials, each with the same probability of success, using the binomial distribution.

- The BINOM.DIST.RANGE function is a statistical function that calculates the probability of achieving a specified range of successes in a given number of independent trials, each with the same probability of success, using the binomial distribution.
- The function takes three required arguments: the number of trials ("trials"), the probability of success on each trial ("probability_s"), and the lower bound for the number of successes ("number_s"). An optional fourth argument ("number_s2") can be provided to specify the upper bound for the number of successes; if omitted, the function calculates the probability of achieving exactly "number_s" successes.
- BINOM.DIST.RANGE requires "trials" to be a whole number (integer) and "probability_s" to be within the range [0, 1]; otherwise, the function returns a #NUM! error. Fractional values for "trials" are not valid.

`=BINOM.DIST.RANGE(10, 0.5, 3)`

This formula calculates the probability of getting exactly 3 successes in 10 independent trials, each with a 50% probability of success (e.g., getting 3 heads in 10 coin flips). The result is the probability of this specific outcome.

`=BINOM.DIST.RANGE(10, 0.5, 3, 5)`

This formula calculates the probability of getting between 3 and 5 successes (inclusive) in 10 independent trials, each with a 50% probability of success (e.g., getting 3, 4, or 5 heads in 10 coin flips). The result is the cumulative probability of getting 3, 4, or 5 successes.