How to Use Excel COMBIN Function in Office 365? – [with Examples]
Tags: excelcombinfunctioni, excelfunctions
Published: 2020-09-11 08:49:31

---
title: How to Use Excel COMBIN Function in Office 365? – [with Examples]
published: true
date: 2020-09-11 07:01:24 UTC
tags: ExcelCOMBINFunctioni,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-excel-combin-function-in-office-365-with-examples/
---

## Excel COMBIN Function:

![COMBIN Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/COMBIN-Function.png)<figcaption id="caption-attachment-13685">COMBIN Function</figcaption>

In this article, you will learn how to use **Excel COMBIN Function in Office 365** with its syntax, description, and examples. 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)

## **COMBIN Function – Description:**

- This function **returns the number of combinations for a given number of items**.
- **COMBIN Function** is used to calculate the total possible number of groups for a given number of items.
- You can use the following formula to calculate **Combinations** for a given number of items.

![Formula and Working Calculation of COMBIN Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Formula-and-Working-Calculation-of-COMBIN-Function.png)<figcaption id="caption-attachment-13679">Formula and Working Calculation of COMBIN Function</figcaption>

## **Syntax:**

**=COMBIN(number, number\_chosen)**

### Arguments Description:

**Number – ** It is the total number of items.

**Number\_chosen – ** The number of items in each combination.

### Note:

- If any argument is non-numeric value and then this function returns [**#VALUE! Error**](https://geekexcel.com/how-to-fix-value-error-in-excel-office-365-with-example/).
- If the input number is less than the number chosen, it returns [**#NUM! Error**](https://geekexcel.com/how-to-fix-num-error-in-excel-office-365-with-example/) value.

## **Examples:**

Let’s see some examples below.

### Example 1:

- Refer to the below screenshot.
- You can see the input numbers are given in **Column A** , and its chosen values are given in **Column B.**
- Its output is listed in **Column D**.

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-36.png)<figcaption id="caption-attachment-13680">Example 1</figcaption>

### Example 2:

- If the input number is less than the number chosen, it returns [**#NUM! Error**](https://geekexcel.com/how-to-fix-num-error-in-excel-office-365-with-example/) value.

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/2-32.png)<figcaption id="caption-attachment-13681">Example 2</figcaption>

### Example 3:

- If any argument is non-numeric value and then this function returns [**#VALUE! Error**](https://geekexcel.com/how-to-fix-value-error-in-excel-office-365-with-example/).

![Example 3](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/3-11.png)<figcaption id="caption-attachment-13682">Example 3</figcaption>

## **Bottom-Line:**

In this article, you can understand the usage of **Excel COMBIN Function in Office 365** with its syntax, description, and examples. Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### See Also:

- [How to Use Excel MODE.MULT Function in Office 365? – (with Examples)](https://geekexcel.com/how-to-use-excel-mode-mult-function-in-office-365-with-examples/)
- [How to Use Excel CSC Function in Office 365? – {with Examples}](https://geekexcel.com/how-to-use-excel-csc-function-in-office-365-with-examples/)