**What does it do?**

Gives you the remainder after dividing one number with another

**Formula breakdown:**

=MOD(number1, number2)

**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**:

## =MOD(

**STEP 2:** The MOD arguments:

**number1**

**number1**

**What is the first number that we plan to divide?**

*Reference the cell that contains the first number:*

## =MOD(C9,

**number2**

**number2**

**What is the divisor?**

*Reference the cell that contains the second number:*

## =MOD(C9, D9)

**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!

HELPFUL RESOURCE:

DO YOU WANT TO GET BETTER AT EXCEL?

If so, join over 45,000 professionals who get career boosting, Free Excel lessons delivered on a weekly basis!

Comments