Returns the number of combinations for a given number of items.
構文
COMBIN(number, number_chosen)引数
number必須
The total number of items.
number_chosen必須
The number of items in each combination.
The COMBIN function calculates the total number of ways to select a subset of items from a larger set, where the order of selection does not matter. It is mathematically equivalent to the binomial coefficient formula nCr.
=COMBIN(5, 2)→10Calculates the number of ways to choose 2 items from a set of 5.
Select a cell
Click on the cell where you want to display the result.
Enter the formula
Type =COMBIN(n, k) replacing n and k with your specific values.
No, COMBIN calculates combinations where order is irrelevant; use PERMUT if order matters.