How to use the BINOM.DIST function in Excel Office 365?
Tags: tousethebinomdistfun, excel, excelfunctions
Published: 2021-08-24 02:19:31

---
title: How to use the BINOM.DIST function in Excel Office 365?
published: true
date: 2021-08-18 19:40:44 UTC
tags: ToUseTheBINOMDISTFun,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-the-binom-dist-function-in-excel-office-365/
---

 **BINOM.DIST** is a **statistical function** that returns the **expected value or the probability of success** in a given number of trials, having a number of successes in a trial and probability of success in a trial. Here I will introduce you to some quick tricks for how to **use the BINOM.DIST Function In Excel Office 365**. Let’s get them below!! Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

## BINOM.DIST Function syntax

```
=BINOM.DIST(number_s, trials, probability_s, cumulative)
```

**Syntax Explanation:**

- **Number\_s** : The number of **successes in trials**.
- **Trials** : The number of **independent trials**.
- **Probability\_s** : The **probability of success on each trial**.
- **Cumulative** : **logical value** that determines the form of the function. If **cumulative is TRUE** , then **BINOM.DIST** returns the **cumulative distribution function,** which is the probability that there are at most **number\_s successes** ; if **FALSE** , it returns the **probability mass function** , which is the probability that there are exact **number\_s successes**.

## Example

- Firstly, you have to create **a sample data** with **2 red balls** and **3 white balls** in a bag.

![](https://geekexcel.com/wp-content/uploads/2021/08/sample-data-8.png)<figcaption>Sample data</figcaption>

- Then, the **BINOM.INV function** to be used we have a **number of trials, probability successes** and **alpha probability**.
- Now, you need to use the basic **formula** of probability.

```
= number of red balls / total number of balls

Which will interpreted as = B2 / B1
```

![](https://geekexcel.com/wp-content/uploads/2021/08/use-formula-3-1024x301.png)<figcaption>Use the formula</figcaption>

- You need to use the **BINOM.DIST** function with the given **parameters** and follow the **formula** given below.

```
=BINOM.DIST(E1,E2,E3,FALSE)
```

![](https://geekexcel.com/wp-content/uploads/2021/08/cumulative-distribution-5-1024x231.png)<figcaption>Cumulative distribution function</figcaption>

- Then, you have to calculate the **probability mass distribution** for the **same parameters** for at most 4 times.
- Now, you need to use the basic **formula** of probability.

```
=BINOM.DIST(E1,E2,E3,TRUE)
```

![](https://geekexcel.com/wp-content/uploads/2021/08/probability-mass-distribution-5-1024x233.png)<figcaption>probability mass distribution</figcaption>

**NOTE:**

- **Number\_s** and **trials** are **truncated to integers**.
- Then, if **number\_s** , trials, or **probability\_s** is **non-numeric** , **BINOM.DIST** returns the **#VALUE! error value**.
- Now, if **number\_s < 0 or number\_s > trials** , **BINOM.DIST** returns the **#NUM! error value**.
- After that, if **probability\_s < 0 or probability\_s > 1** , **BINOM.INV** returns the **#NUM! error value**.
- Finally, you have to use **cumulative argument as TRUE** for the **cumulative distribution or FALSE** for probability mass distribution.

## Verdict

From this chapter, you can get some clarification about **how to use the BINOM.DIST Function In Excel Office 365**. Let me know if you have any **doubts** regarding this article or any other Excel/VBA topic.

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Keep Reading:**

- **[Excel Formulas to Calculate the Cumulative Loan Interest ~ Easily!!](https://geekexcel.com/excel-formulas-to-calculate-the-cumulative-loan-interest-easily/)**
- **[Formulas to Generate Random Number Weighted Probability!!](https://geekexcel.com/excel-formulas-to-generate-random-number-weighted-probability/)**
- **[Excel Date and Time Functions in Office 365!!](https://geekexcel.com/date-and-time-functions-in-microsoft-excel-365/)**
- **[Formulas to Calculate the Cumulative Loan Principal Payments!!](https://geekexcel.com/excel-formulas-to-calculate-the-cumulative-loan-principal-payments/)**