Related Topics: | ||
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
© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.