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)