# 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:

Syntax: =BINOM.DIST.RANGE(B1,B2,B4)
Result: 0.081675913

Syntax: =BINOM.DIST.RANGE(B1,B2,B5)
Result: 0.008006662

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

Syntax: =BINOM.DIST.RANGE(B1,B2,B4,B5)
Result: 0.237912905

Syntax: =BINOM.DIST.RANGE(B1,B2,B6,B7)
Result: 5.002E-05

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: READ:  How to use FORECAST.ETS.STAT Function in Excel