COMBIN function
COMBIN(NumberOfItems, NumberChosen) COMBIN(NumberOfItems; NumberChosen)
NumberOfItems
Number or { Number }
The number of items.
NumberChosen
Number or { Number }
The number of items in each combination.
Returns
Number or { Number }
The number of combinations.
Returns the number of combinations for a certain number of items.
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 }.