## What is BINOM.DIST.RANGE function in Excel?

The BINOM.DIST.RANGE function is one of the **Statistical **functions of Excel.

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

We can find this function in **Statistical **category of insert function Tab.

## How to use BINOM.DIST.RANGE function in excel

- Click on
**an empty cell**(like F5).

2. Click on the **fx icon **(or press shift+F3).

3. In the **insert function tab** you will see all functions.

4. Select **STATISTICAL **category.

5. Select **BINOM.DIST.RANGE** function.

6. Then select **ok**.

7. In the function arguments Tab you will see **BINOM.DIST.RANGE** function.

8. Trials are the number of **independent **trials.

9. Probability _s is the probability of **success **on each trial.

10. Number s is the number of successes in trials.

11. Number s2 if provided this function returns the probability that the number of successful trials shall lie between number s and number s2.

12. You will see the **results **in the formula result section.

## Examples of BINOM.DIST.RANGE function in Excel

## BINOM.DIST.RANGE related functions

- Use BINOM.DIST function to return the individual term binomial distribution probability.
- Use BINOM.INV function to return the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.