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.