COMBIN function

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)

The COMBIN function syntax has the following arguments:

• number Required. The number of items. This value cannot be less than zero. It must be greater or cannot be less than number_chosen.
• number_chosen Required. The number of items in each combination. This value cannot be less than zero and cannot be greater than number.

Notes

• Numeric arguments are truncated to integers (for example, 6.8 truncates to 6).
• An error occurs if either argument is nonnumeric.
• An error occurs if either argument is less than 0 or if number is less than number_chosen.
• Unlike a permutation, a combination is any set or subset of items, regardless of their internal order.
• The number of combinations is as follows, where number = n and number_chosen = k:

  

  where:

  

Example

Calculate number of possible teams that may be created from a set of Candidates.