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
Search JabSto ::

Custom Search