Saturday, 3 September 2016

Excel COMBIN Function | How to use the COMBIN Function


How to use the COMBIN Function


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.















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 2





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








No comments:

Post a Comment