Related Topics:
	Spreadsheet Mathematical Functions Data Entry Tips for Functions

COMBIN

Description: Returns the number of combinations for a given number of objects. 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:

• Both arguments must be numerical integers >= 0 and Number >= Number_chosen.

• A combination is any set or subset of items, regardless of their internal order. Combinations are distinct from permutations, for which the internal order is significant.

• The number of combinations is calculated as follows:

where:

Example:

• Determine the possible two-person teams that can be formed from 8 candidates.

COMBIN(8,2) = 28