COMBIN

Returns the number of combinations for a given number of items. Use COMBIN to determine the total possible number of groups 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.

Remarks

Example

Suppose you want to form a two-person team from eight candidates, and you want to know how many possible teams can be formed. COMBIN(8, 2) equals 28 teams.


Send feedback to MSDN.Look here for MSDN Online resources.