Combin
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) |
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.
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.
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.
How many colours schemes can be created ?
Available Colours | Colours Per Scheme | Totals Schemes | |
5 | 3 | 10 | =COMBIN(C41,D41) |
The colours |
Red |
Green |
Blue |
Yellow |
Black |
Scheme 1 | Scheme 2 | Scheme 3 | Scheme 4 | Scheme 5 |
Red | Red | Red | Red | Red |
Green | Green | Green | Blue | Blue |
Blue | Yellow | Black | Yellow | Black |
Scheme 6 | Scheme 7 | Scheme 8 | Scheme 9 | Scheme 10 |
Green | Green | Green | Blue | ?????? |
Blue | Blue | Yellow | Yellow | |
Yellow | Black | Black | Black |