COMBIN

Posted on 17-01-2020 , by: admin , in , 0 Comments

Combin

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.


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
Sch 1 Sch 2 Sch 3 Sch 4 Sch 5
Red Red Red Red Red
Green Green Green Blue Blue
Blue Yellow Black Yellow Black
Sch 6Sch 7Sch 8Sch 9Sch 10
GreenGreenGreenBlue??????
BlueBlueYellowYellow 
YellowBlackBlackBlack 

 

Leave a comment