Microsoft Office Tutorials and References
In Depth Information
Using MOD to Find the Remainder Portion of a Division Problem
Figure 11.28.
Figure 11.28. Solving this problem with
will amuse Boy
Scout groups and middle school math students.
Solving this problem with MULTINOMIAL
MULTINOMIAL will amuse Boy
Scout groups and middle school math students.
Someone figured out that the answer to this problem is the factorial of (Di-
viders + Coins) / Factorial of Coins × Factorial of Dividers. In math terms,
this is (3+6)! / 3!×6!. Remarkably, Excel has a function for solving the coin
problem. =MULTINOMIAL(3,6) performs the calculation (3+6)! / 3!×6!.
Using
Using MOD
to Find the Remainder Portion of a Division Problem
The MOD function is one of the obscure math functions that I find myself us-
ing quite frequently. Have you ever been in a group activity where everyone
in the group was to count off by sixes? This is a great way to break up a
group into six subgroups. It makes sure that friends who were sitting together
get put into disparate groups.
Using the MOD function is a great way to perform this concept with records
in a database. Perhaps for auditing, you need to check every eighth invoice.
Or you need to break up a list of employees into four groups. You can solve
these types of problems by using the MOD function.
Think back to when you were first learning division. If you had to divide 43
by 4, you would have written that the answer was 10 with a remainder of 3. If
you divide 40 by 4, the answer is 10 with a remainder of 0.
The MOD function divides one number by another and reports back just the
remainder portion of the result. You end up with an even distribution of re-
mainders. If you convert the formulas into values and sort, your data is
broken into similar-size groups.
MOD to Find the Remainder Portion of a Division Problem
Syntax
=MOD(number,divisor)
The MOD function returns the remainder after numberis divided by divisor.
The result has the same sign as divisor. This function takes the following
arguments:
number
number This is the number for which you want to find the remainder.
divisor
divisor This is the number by which you want to divide number. If
divisoris 0, MOD returns a #DIV/0! error.
Search JabSto ::

Custom Search