Microsoft Office Tutorials and References

In Depth Information

**Using QUOTIENT to Isolate the Integer Portion in a Division Problem**

Note

MOD is short for modulo, the mathematical term for this operation.

You would normally say that 17 modulo 3 is 2.

The MOD function is good for classifying records that follow a certain or-

der. For example, the SmartArt gallery contains 84 icons arranged with four

icons per row. To find the column for the 38th icon, use =MOD(38,4).

The example in
Figure 11.29
assigns all employees to one of four groups.

Figure 11.29.

Figure 11.29.
To organize these employees into four groups, use

To organize these employees into four groups, use

=MOD(ROW(),4)

=MOD(ROW(),4). Then paste the values and sort by the remainders.

. Then paste the values and sort by the remainders.

Using

Using
QUOTIENT

to Isolate the Integer Portion in a Division Problem

As you just learned, the MOD function isolates the remainder portion in a

division problem. The QUOTIENT function isolates the integer portion in a di-

vision problem.

QUOTIENT
to Isolate the Integer Portion in a Division Problem