Microsoft Office Tutorials and References
In Depth Information
Using What Remains with the MOD Function
Figure 8-2 shows this on a worksheet. Cell C10 shows the result of multiplying
12 numbers, although only three arguments, as ranges, have been used in the
function.
Figure 8-2:
Putting the
PRODUCT
function
to work.
Using What Remains with
the MOD Function
The MOD function returns the remainder from an integer division operation.
This is called the modulus , hence the function’s name. The function has two
arguments: the number being divided and the number being used to divide
the first argument. The second argument is the divisor. The syntax follows:
=MOD(number, divisor)
These are examples of the MOD function:
=MOD(12,6) returns 0
=MOD(14,5) returns 4
=MOD(27,7) returns 6
=MOD(25,10) returns 5
=MOD(25,10) returns –5
=MOD(15.675,8.25) returns 7.425
The returned value is always the same sign as the divisor.
Search JabSto ::




Custom Search