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

Returns the probability of a trial result using a binomial distribution.

 trials The number of independent trials. probability_s The probability of success in each trial. number_s The number of successes in trials. number_s2 (Optional) The upper value for a number of successes, between "number_s" and "number_s2".

#### Remarks

 * Added in Excel 2013.* BINOM.DIST.RANGE(n, p, x, y) = the probability there are between x and y successes (inclusive) in n trials where the probability of success on any trial is p * BINOM.DIST.RANGE(n, p, x, y) = BINOMDIST(y, n, p, TRUE) - BINOMDIST(x-1, n, p, TRUE) if x > 0* BINOM.DIST.RANGE(n, p, 0, y) = BINOMDIST(y, n, p, TRUE).* BINOM.DIST.RANGE(n, p, x) = BINOMDIST(x, n, p, FALSE).* If "trials" < 0, then #NUM is returned.* If "numbers" < 0, then #NUM is returned.* If "numbers_s" > "trials", then #NUM is returned.* If "trials" is not numeric, then #VALUE is returned.* If "probability_s" is not numeric, then #VALUE is returned.* If "number_s" is not numeric, then #VALUE is returned.* If "number_s2" is not numeric, then #VALUE is returned.* If "number_s2" is left blank, then ??* If "number_s2" < "number_s", then #NUM is returned* If "number_s2" > "trials", then #NUM is returned.* For the Microsoft documentation refer to support.microsoft.com

 A 1 ??