Excel: Combin Function
In Excel, the Combin function returns the combinations for a specified number of items.
The syntax for the Combin function is:
Combin( number, chosen )
number is the number of items.
chosen is the number of items in a combination.
Applies To:
- Excel 2007, Excel 2003, Excel XP, Excel 2000
For example:
Let's take a look at an example:
Based on the Excel spreadsheet above:
=Combin(A1, A2) would return 252 =Combin(A1, A3) would return 120 =Combin(21, 5) would return 20349