Excel COMBIN function

Function              COMBIN

Description        Excel COMBIN function returns the number of combinations in any order of a given number of items.

Syntax  COMBIN(number, number_chosen)

number  The total number of items.

number_chosen  The number of items in each combination.

Example:

=COMBIN(33,2) = 528

It means 33 people can be grouped of 2 in 528 orders.

=COMBIN(8,3) = 56

It means 8 people can be grouped of 3 in 56 orders.

Usage Notes:

• If input that decimal values integer part is only taken.
• COMBIN returns a #VALUE! error value if either input is not numeric.
• If number is less than number_chosen then it returns #NUM! error.