## What is COMBINA Function in Excel?

The **COMBINA **function is one of the math functions of Excel.

It Returns the number of combinations with **repetitions for a given number **of items.

We can find this function in **Math & trig** category of insert function Tab.

## How to use COMBINA function in excel

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

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

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

4. Select **math and trig** category

5. Select **COMBINA **function

6. Then select **ok**

7. In the function arguments Tab you will see **COMBINA **function

8. Number is the **total number of items**

9. Number_chosen is the **number of items **in each combination

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

## Examples of **COMBINA** function in Excel

**Example 1:**

**How to use COMBINA function in excel**

You can see examples of COMBINA function below:

**combina**(A2,B2) ----->>>>answer is 5
**combina**(A3,B3) ----->>>>answer is 15
**combina**(A4,B4) ----->>>>answer is 35
**combina**(A5,B5) ----->>>>answer is 70
**combina**(A6,B6) ----->>>>answer is 126

## What is the purpose of **COMBINA** function?

**COMBINA**

It Returns the number of combinations with **repetitions for a given number **of items.

## What is the Return value of **COMBINA** function?

**COMBINA**

It returns a number.

## How many arguments does **COMBINA** function have?

**COMBINA**

This function has just **1** Argument.

The **argument **of COMBINA function is **number**.

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

Number_chosen is the **number of items **in each combination.

The argument of COMBINA function is **required **and not optional.

```
COMBINA(number) = number
```

## Which version of excel supports **COMBINA** function?

**COMBINA**

This function is available for all excel **versions **(2003-2019)

## Errors in **COMBINA** function

**COMBINA**

## COMBINA** related functions :**

- COMBIN function
- PERMUT function
- PERMUTATIONA function