How to use the BINOM.INV function in Excel office 365?
Tags: tousethebinominvfunc, excel, excelfunctions
Published: 2021-08-24 02:19:11

---
title: How to use the BINOM.INV function in Excel office 365?
published: true
date: 2021-08-18 19:40:42 UTC
tags: ToUseTheBINOMINVFunc,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-the-binom-inv-function-in-excel-office-365/
---

 **BINOM.INV** is a **statistical function** that returns the **minimum value of trials** for which the **Cumulative Binomial Distribution function** is a given **probability**. In this tutorial, we are going to see how to **use the BINOM.INV Function In Excel Office 365**. Let’s get into this article!! 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.INV Function syntax

```
=BINOM.INV(trials, probability_s, alpha)
```

**Syntax Explanation:**

- **Trials** : The number of **independent trials**.
- **Probability\_s** : The **probability of success** on each trial.
- **alpha** : **criterion value** , the **probability of the Cumulative Binomial Distribution** (must be between 0 and 1).

## 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-7.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 be interpreted as = **B2 / B1**.
```

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

- By using the **probability value** , you have to calculate the **minimum number of trials** required to get the **red ball**.
- For that, you need to use the **BINOM.INV function** with the given **parameters** and follow the **formula** given below.

```
 =BINOM.INV( B1, B2, B3) 
```

![](https://geekexcel.com/wp-content/uploads/2021/08/no-of-trials-1024x192.png)<figcaption>Use the BINOM.INV function</figcaption>

**NOTE:**

- The BINOM.INV Function only works with **numbers**.
- You have to feed the **arguments directly** or using the **cell reference** as stated in the example above.
- The BINOM.INV function is the **updated version**  **of the**  **CRITBINOM function**.
- Then, the **trials** are **truncated to integers**.
- Now, if **alpha, trials, or probability\_s** is **non-numeric** , **BINOM.INV** returns the **#VALUE! error value**.
- After that, if **alpha < 0 or alpha > 1** , **BINOM.INV** returns the **#NUM! error value**.
- Finally, if **probability\_s < 0 or probability\_s > 1** , **BINOM.INV** returns the **#NUM! error value**.

## Verdict

We hope that this short tutorial gives you guidelines to **use the BINOM.INV Function In Excel Office 365. ** Please leave a comment in case of any **queries,** and don’t forget to mention your valuable **suggestions** as well. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!! **Read more on [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Read Also:**

- **[How to use the CHISQ.DIST function in Excel office 365?](https://geekexcel.com/how-to-use-the-chisq-dist-function-in-excel-office-365/)**
- **[How to Hide a Worksheet in Microsoft Excel 365?](https://geekexcel.com/how-to-hide-a-worksheet-in-microsoft-excel-365/)**
- **[Select Cells with Error Values in Excel Office 365](https://geekexcel.com/how-to-select-cells-with-error-values-in-excel-office-365/)**
- **[Find the Last Column of Data in Excel Office 365](https://geekexcel.com/how-to-find-the-last-column-of-data-in-excel-office-365/)**
- **[Excel Formulas to Generate Random Number Weighted Probability!!](https://geekexcel.com/excel-formulas-to-generate-random-number-weighted-probability/)**