## What Is COMBIN Function In Excel?

The

COMBIN function in Excelhelps users estimate the number of combinations or possible groups that can be formed from a dataset. The order of the selected values doesn’t matter, and repetitions are not allowed by the function. TheCOMBIN function,from the Math & Trig group, is an inbuilt function, so we can insert the formula from the “Function Library” or enter it directly in the worksheet.

For example, we will apply the **COMBIN function in Excel **to calculate the combination values of the given numbers.

Select cell **A2**, enter the formula ** =COMBIN(3,2), **and press “

**Enter**.” The result is ‘

**3**,’ as shown above, i.e., the combination of ‘a,’ ‘b,’ & ‘c’ in 2 digits.

##### Table of contents

###### Key Takeaways

- The
**COMBIN function in Excel**is a mathematical function that returns the combination of data values. - If the arguments
and*number*are decimal values, then the function only considers the whole integer.*number_chosen* - Excel
**COMBINA**and**COMBIN**functions both calculate combinations of a set of objects or several items. The difference between these functions is the**COMBINA**function counts repetitions of combinations, whereas the**COMBIN**function does not count the repetitions. - When we have a list with duplicate entries, the function will give incorrect results, as the function only counts unique entries.

### COMBIN() Excel Formula

The syntax of the **COMBIN Excel formula **is,

The arguments of the **COMBIN Excel formula **are,

: It is a mandatory argument. It is the cell value to find the combination, which has to be greater than or equal to 0 and the*number**number_chosen.*: It is a mandatory argument. It is the number of groups/digits to be formed in each combination. It is always a number and should be greater than or equal to 0.*number_chosen*

**Excel VBA – All in One Courses Bundle (35+ Hours of Video Tutorials)**

**Excel VBA – All in One Courses Bundle (35+ Hours of Video Tutorials)**

If you want to learn Excel and VBA professionally, then Excel VBA All in One Courses Bundle (35+ hours) is the perfect solution. Whether you’re a beginner or an experienced user, this bundle covers it all – from Basic Excel to Advanced Excel, Macros, Power Query, and VBA.

### How To Use COMBIN Excel Function?

We can use the **COMBIN Excel function** in 2 ways, namely,

**Access from the Excel ribbon.****Enter in the worksheet manually.**

#### Method #1 – Access from the Excel ribbon

First, choose an empty cell → select the **“Formulas” **tab → go to the “**Function Library**” group → click the **“Math & Trig” **option drop-down → select the **“COMBIN”** function, as shown below.

The **“Function Arguments” window appears**. Enter the argument values in the “**Number”, **and** “Number_chosen”** fields → click “**OK**”, as shown below.

#### Method #2 – Enter in the worksheet manually

- Select an empty cell for the output.
- Type
**=COMBIN(**in the selected cell. [Alternatively, type “=C” and double-click the**COMBIN function**from the list of suggestions shown by Excel.] - Enter the arguments as cell values or cell references and close the brackets.
- Press the “
**Enter**” key.

Let us understand this function with a basic example.

We will calculate the combination of numbers of the given data **using** **COMBIN function in Excel**.

In the table, the data is,

- Column A: contains Values.
- Column B: contains Output.

The steps to calculate the combination using **COMBIN function in Excel** are,

**Select cell B2, and enter the formula =COMBIN(5, i.e., 5 is the number value.****In continuation with the formula, enter the value of ‘number_chosen’ as “A2”, and close the brackets. The complete formula is =COMBIN(5,A2).****Press the “Enter” key. The result is 5, as shown below.****Drag the formula from cell B2 to B6 using the fill handle.**

The output is shown above.

### Examples

We will understand some advanced scenarios using the **COMBIN function in Excel examples.**

#### Example #1

We will calculate the combination of numbers of the given data using the **COMBIN function in Excel**. In the table, the data is,

- Column A: contains the Result.

The procedure to calculate the combination using the **COMBIN function** is,

**Step 1:**Select cell**A2**, enter the formulathe “*=COMBIN(15,2), and press***Enter**” key.

The result is “**105**”, as shown above.

#### Example #2

We will calculate the combination of numbers of the given data using the **COMBIN function**.

In the table, the data is,

- Column A: contains Values.
- Column B: contains Output.

The procedure to calculate the combination using the **COMBIN function in Excel** is,

**Step 1:**Select cell**B2**, enter the formulaand press the “*=COMBIN(A2,A3),***Enter**” key.

The result is “**252**”, as shown above.

#### Example #3

We will calculate the combination of numbers of the given data using the **COMBIN function in Excel**.

In the table, the data is*,*

- Column A: contains the Number.
- Column B: contains Number_chosen.

The steps to calculate the combination using the **COMBIN function** are,

**Step 1:**Select cell**C2,**enter the formula*=COMBIN(A2,B2),***Enter**” key. The result is “**45**”, as shown below.

**Step 2:**Drag the formula from cell**C2**to**C3**using the fill handle.

The output is shown above.

### Important Things to Note

- The
**#VALUE!**error occurs if theand*number*arguments are cell references with non-numeric values.*number_chosen* - The
**#NAME?**error occurs if theand*number*arguments are non-numeric values.*number_chosen* - The
**#NUM!**error occurs when the value or argument is outside its constraint.- The input
argument is less than 0 or a negative number.*number* - The input
argument is less than 0 or is greater than the number argument.*number_chosen*

- The input

### Frequently Asked Questions (FAQs)

**1. What does the COMBIN function do in Excel?**

The **COMBIN function in Excel,** aka the combination function, calculates the number of possible combinations for two given numbers.

The syntax of the COMBIN function is *=COMBIN(number,number_chosen)*

**2. How does the COMBIN function work in Excel?**

The **COMBIN function in Excel** works in Excel as follows:

1. Select an empty cell for the output.

2. Type **=COMBIN(** in the selected cell. [Alternatively, type “=C” and double-click the **COMBIN function **from the list of suggestions shown by Excel.]

3. Enter the arguments as cell values or cell references and close the brackets.

4. Press the “**Enter**” key.

For example, we will use the **COMBIN function** to calculate the combination of the following data.

Select cell **A2**, enter the value ** =COMBIN(3,3), and press** the “

**Enter**” key.

The result is “

**1**”, as shown above.

**3. Where is the COMBIN function in Excel?**

The **COMBIN function in Excel **is in the “**Formulas**” tab and can be inserted as follows:

First, choose an empty cell → select the **“Formulas” **tab → go to the “**Function Library**” group → click the **“Math & Trig” **option drop-down → select the **“COMBIN”** function, as shown below.

### Download Template

This article must help understand the **COMBIN function in Excel’s** formula and examples. You can download the template here to use it instantly.

### Recommended Articles

This has been a guide to COMBIN Function In Excel. Here we find number of combinations formed using data values, examples & a downloadable excel template. You can learn more from the following articles –

## Leave a Reply