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 )
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 COMBIN function

6. Then select ok

excel COMBIN function

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

How to use COMBIN function in excel

Examples of COMBIN function in Excel

Example 1:

How to use COMBIN function in excel

You can see examples of COMBIN function below:

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

Leave a Reply

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