Excel COMBIN Function

What is COMBIN Function in Excel?

The COMBIN function is one of the math functions of Excel.

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

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

How to use COMBIN 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 COMBIN function

6. Then select ok

7. In the function arguments Tab you will see COMBIN 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 COMBIN function in Excel

Example 1:

How to use COMBIN function in excel

You can see examples of COMBIN function below:

combin(A2,B2) ----->>>>answer is  5

combin(A3,B3) ----->>>>answer is  10

combin(A4,B4) ----->>>>answer is  10

combin(A5,B5) ----->>>>answer is  5

combin(A6,B6) ----->>>>answer is  1

What is the purpose of COMBIN function?

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

What is the Return value of COMBIN function?

It returns a number.

How many arguments does COMBIN function have?

This function has just 2 Argument.

The argument of COMBIN function is number.

Number is the total number of items.

Number_chosen is the number of items in each combination.

The argument of COMBIN function is required and not optional.

COMBIN(number) = number

Which version of excel supports COMBIN function?

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

Errors in COMBIN function

COMBIN related functions :

• COMBINA function
• PERMUT function
• PERMUTATIONA function
• FACT function