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 }.