The COMBIN function returns the number of combinations for a given number of items.
|number||The number of objects in the set|
|number_chosen||The number of items in each combination|
|2||=COMBIN(8,2)||28||Possible two-person teams that can be formed from 8 candidates|
|3||=COMBIN(6,2)||15||Possible two-person teams that can be formed from 6 candidates|
|4||=COMBIN(6,3)||20||Possible three-person teams that can be formed from 6 candidates|
Usage note: Use COMBIN to determine the total possible number of groups for a given number of items.
Common Function Error(s)
|Problem||What went wrong|
|#VALUE!||Occurs if either of the supplied arguments is non-numeric|
|#NUM!||Occurs if either:
For example, in a set of 3 objects, a, b, c, how many combinations of 2 objects are there?
- COMBIN returns the result 3; combinations are: ab, ac, bc
The number of combinations is calculated as follows, where number = n and number_chosen = k: