In this guide, we’re going to show you how to get division remainders in Excel using the MOD function. This function is frequently used in mathematical and logical calculations. You can create distributions, create a switch mechanism, and more with the MOD function.

Download Workbook

Modulo Operation

The MOD function is named the modulo operation. Modulo operation is a computing term which returns the remainder of a division, after one number is divided by another number (modulus).

7 mod 3 returns 14 mod 2 returns 0

The MOD function handles the calculation the same as above in Excel.

The MOD Function

The MOD function is a fairly straightforward function that returns the remainder for a given number and divisor and you get division remainders as a result.

MOD(number, divisor)

number The numeric value for which you want to find the remainder.
divisor The numeric value to divide the number with.

get division remainders

Don't need to get division remainders but interested in the integer portion of a division by discarding the remainder portion? Check out the QUOTIENT function on how to do this.