# BINOM.DIST.RANGE

Returns the probability of drawing a specific number of successes or range of successes given a probability and number of tries.

### Parts of a BINOM.DIST.RANGE function

BINOM.DIST.RANGE(num_trials, prob_success, num_successes, max_num_successes)

 Part Description num_trials The number of independent trials. Must be greater than or equal to 0. prob_success The probability of success in any given trial. Must be between 0 and 1, both exclusive. num_successes The number of successes for which to calculate the probability in `num_trials` trials. Must be between 0 and num_trials, both exclusive. max_num_successes Optional: The maximum number of successes for which to calculate the  probability in `num_trials` trials. If omitted, then we compute the probability of  just `num_successes`. Must be between num_successes and num_trials, both exclusive.

### Notes

• If any arguments does not meet its constraints, this function returns a #NUM! error value.
• If any argument is non-numeric, this functions returns a #VALUE! error value.
• Except for prob_success, this function truncates any numerical argument to an integer.

### Examples

 A B 1 Function input Function output 2 =BINOM.DIST.RANGE(100, 0.5, 45) 0.04847429663 3 =BINOM.DIST.RANGE(100, 0.5, 30, 45) 0.1840847287 4 =BINOM.DIST.RANGE(100, 0.5, 30) 0.00002317069058

### Related functions

• BINOM.DIST/BINOMDIST

Search
Clear search
Close search