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