Tuesday, June 14, 2011

In Excel Find number of combinations for fixed number of items.

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.


Example 1
This example calculates the possible number of pairs of letters available from the four characters ABCD.


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 ?


Twitter Bird Gadget