How to use BINOM.DIST.RANGE Function in Excel

The Excel Binom.Dist.Range function returns the Binomial Distribution probability for the number of successes from a specified number of trials falling into a specified range.

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

The BINOM.DIST.RANGE function syntax has the following arguments:

• Trials    Required. The number of independent trials. Must be greater than or equal to 0.
• Probability_s    Required. The probability of success in each trial. Must be greater than or equal to 0 and less than or equal to 1.
• Number_s    Required. The number of successes in trials. Must be greater than or equal to 0 and less than or equal to Trials.

• Number_s2    Optional. If provided, returns the probability that the number of successful trials will fall between Number_s and number_s2. Must be greater than or equal to Number_s and less than or equal to Trials.

Example: Let’s look at some Excel BINOM.DIST.RANGE function examples and explore how to use the BINOM.DIST.RANGE function as a worksheet function in Microsoft Excel:

Syntax:  =BINOM.DIST.RANGE(B1,B2,B3)

Result: 0.000548825

Based on the Excel spreadsheet above, the following BINOM.DIST.RANGE examples would return:

Note:

1. The function will truncate all numerical values to integer.
2. #VALUE! error – Occurs when any of the arguments provided is non-numeric.
3. #NUM! error – Occurs when:
   1. The given probability is less than zero or greater than 1.
   2. The given number_s is less than zero or greater than the trials argument.
   3. The given number_s2 is less than zero or greater than trials or less than number_s.
4. The following equation is used: