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

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

- The following equation is used: