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 color scheme for a new office.
The decorator is given five colors to work with, but can only use three in any scheme.
How many colours schemes can be created ?
No comments:
Post a Comment