|
We also have Free
training videos on this site ( visit the
Home page
or the
Training Page)
The COMBIN formula is extremely useful as it is used to derive at a number of combinations for a specific total of items. The COMBIN formula can thus be used to get the possibilities of groups for a total number of items and looks like this:
|
COMBIN (the number, chosen)
With the COMBIN formula the number represents
the number of items and the chosen number will thus represent the
number of items in each possible combination.
In this function numeric arguments must be truncated to integers
to prevent #VALUE! Error.
The combination can thus be any sub set of items. The internal
order doesn’t make a difference.
An example of how the function looks is provided below:
=COMBIN(B6,B7)
=COMBIN(28,5)
|
|
The possible combinations will be returned for the number of
items. You can thus work out the number of combinations that can be
obtained.
ABS
Another useful mathematical function is that of ABS which returns
the absolute value of a number and looks like this:
=ABS(number) or =ABS(2) which thus stands for the absolute value
of 2 and will have the answer of 2.
ODD
The function is used to round numbers up to the nearest odd
integer and looks like this:
=ODD(5) which will thus round 3 up to the nearest integer (3).
If the number is an odd number no rounding takes place.
For more on the COMBIN formula and other
mathematical functions in Excel, click on the training index button.
|
