What does it do?
Gives you the remainder after dividing one number with another
What it means:
=MOD(a number, divided by this number)
In Excel it is very easy to divide two numbers.
But how about if you need to get the remainder from a division operation?
For example, divide 13 by 4:
- Divide the two numbers (i.e. 13 / 4)
- Get the quotient (which is 3)
- Multiply it back to the divisor (3 * 4)
- Subtract it from the original number (13 – 12)
- And I have the remainder! (1)
So, 4 goes into 13 three times with a remainder of 1.
Thankfully we can do the above complex and manual calculation with ease using Excel’s MOD formula!
I explain how you can do this below:
STEP 1: We need to enter the MOD function:
STEP 2: The MOD arguments:
What is the first number that we plan to divide?
Reference the cell that contains the first number:
What is the divisor?
Reference the cell that contains the second number:
STEP 3: Do the same for the rest of the cells by dragging the MOD formula all the way down using the left mouse button.
Now you are able to get the remainders of all the division operations!