Microsoft Office Tutorials and References
In Depth Information
Calculating a Remainder
Calculating a Remainder
When you divide two numbers, if the result isn’t a whole number, you end up with a remainder.
When Excel performs division, the result is a decimal value. How can you determine the
remainder (if any) that results from a division?
The solution is to use the MOD function, which takes two arguments: the number and the divisor.
The MOD function returns the remainder.
For example, if you have 187 books to be divided equally among 5 offices, how many will be left
over? Use this formula to determine the number of books per office (which is 37):
=INT(187/5)
Use this formula to calculate how many books will be left over (which is 2):
=MOD(187,5)
 
Search JabSto ::




Custom Search