Site icon ExcelNotes

How to Use COMBIN Function

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.

Download: COMBIN Function

Exit mobile version