What Does it Do?
This function calculates the highest number of combinations available based upon
a fixed number of items.
The internal order of the combination does not matter, so AB is the same as BA.
Syntax
=COMBIN(HowManyItems,GroupSize)
Formatting
No special formatting is required.
Pool Of Items
Items In A Group
Possible Groups
4
2
6
=COMBIN(C4,D4)
4
3
4
=COMBIN(C5,D5)
26
2
325
=COMBIN(C6,D6)
Example 1:
This example calculates the possible number of pairs of letters available from the four characters ABCD.
Total Characters
Group Size
Combinations
4
2
6
=COMBIN (C25,D25)
The proof !
The four letters :
ABCD
Pair 1
AB
Pair 2
AC
Pair 3
AD
Pair 4
BC
Pair 5
BD
Pair 6
CD
Example 1:
A decorator is asked to design a colour scheme for a new office. The decorator is given five colours to work with, but can only use three in any scheme.