How to Use COMBIN Function

The COMBIN function returns the number of combinations for a given number of items.


=COMBIN(number, number_chosen)


– The number is required, the number of items.

– The number_chosen is required, the number of items in each combination.


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.

Download: COMBIN Function

Leave a Reply