COMBIN (NumberOfItems, NumberChosen) COMBIN (NumberOfItems; NumberChosen)
NumberOfItems
Number Number
The number of items.
NumberChosen
Number Number
The number of items in each combination.
Returns
Number Number
The number of combinations.
Returns the number of combinations for a certain number of items. This is the number of ways of choosing a number of items from a set of items, if the order of the chosen items does not matter and an item cannot be chosen twice. Use PERMUT if the order matters.
Examples
COMBIN (4, 2)
COMBIN (4; 2)
Returns 6.
COMBIN (4, 4)
COMBIN (4; 4)
Returns 1.
COMBIN (8, 2)
COMBIN (8; 2)
Returns 28.
COMBIN (8, 4)
COMBIN (8; 4)
Returns 70.
COMBIN (8, { 2, 4 })
COMBIN (8; { 2; 4 })
Returns the array { 28, 70 }{ 28; 70 }.
COMBIN ({ 4, 8 }, { 2, 4 })
COMBIN ({ 4; 8 }; { 2; 4 })
Returns the array { 6, 70 }{ 6; 70 }.
COMBIN (49, 6)
COMBIN (49; 6)
Returns 13983816, the number of ways of choosing six numbers out of 49 in a lottery.