The COMBIN function returns the number of combinations for a given number of items.
Formula:
=COMBIN(number, number_chosen)
Explanations:
– The number is required, the number of items.
– The number_chosen is required, the number of items in each combination.
Cautions:
The number of combinations formula is
where number = n and number_chosen = k.
When the number < 0, number_chosen < 0, or number < number_chosen, COMBIN returns the #NUM! error value.