Excel COMBINA Function

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

1. 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?

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

What is the Return value of COMBINA function?

It returns a number.

How many arguments does COMBINA function have?

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?

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

Errors in COMBINA function

COMBINA related functions :

• COMBIN function
• PERMUT function
• PERMUTATIONA function