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 )
empty cell in excel

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

 fx icon in excel

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

insert function tab in excel

4. Select math and trig category

5. Select COMBINA function

6. Then select ok

 excel COMBINA function

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

How to use COMBINA function in excel

Examples of COMBINA function in Excel

Example 1:

How to use COMBINA function in excel

You can see examples of COMBINA function below:

Examples of COMBINA function in Excel
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 :

Leave a Reply

Your email address will not be published. Required fields are marked *