COMBIN Function
Calculates the number of combinations without repetitions for a given number of items
Calculates the number of combinations without repetitions for a given number of items
The COMBIN Function is a Math and Trigonometry function. The function will calculate the number of combinations without repetitions for a given number of items. It was introduced in MS Excel 2000.
=COMBIN(number, number_chosen)
The COMBIN function uses the following arguments:
To understand the uses of this function, let’s consider few examples:
Suppose we are given six numbers: 1, 2, 3, 4, 5, 6. Now let’s see how the COMBIN function calculates the number of combinations (without repetitions) for the other numbers of objects taken from a set of 4.
For any six objects such as “a, b, c, d, e, f,” there are 15 different combinations (without repetitions) of two objects. These are:
ab, ac, ad, ae, af, bc, bd, be, bf, cd, ce, cf, de, df, ef
The COMBIN Function helps to derive such combinations as shown above. The number of combinations is as follows, where number = n and number_chosen = k:
Let’s now see how we can use this function in day-to-day life. Suppose there are 15 students and we wish to pair them into two-person teams. Using the COMBIN function, we can see the possible two-person teams that can be formed from 15 students.
As seen above, 105 combinations without repetitions are possible.
The COMBIN and COMBINA functions differ in the following ways:
Click here to download the sample Excel file
Thanks for reading CFI’s guide to important Excel functions! By taking the time to learn and master these functions, you’ll significantly speed up your financial analysis. To learn more, check out these additional resources:
To master the art of Excel, check out CFI’s FREE Excel Crash Course, which teaches you how to become an Excel power user. Learn the most important formulas, functions, and shortcuts to become confident in your financial analysis.
Launch CFI’s Free Excel Course now to take your career to the next level and move up the ladder!