COMBIN function

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

Syntax

COMBIN (number,number_chosen)

Number is the number of items.

Number_chosen is the number of items in each combination.

Example

=COMBIN(8,2) returns possible two-person teams that can be formed from 8 candidates: 28.