What does it do?

Gives you the remainder after dividing one number with another

Formula breakdown:

=MOD(number1, number2)

What it means:

=MOD(a numberdivided 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:

DOWNLOAD EXCEL WORKBOOK

 

STEP 1: We need to enter the MOD function:

=MOD(

 

STEP 2: The MOD arguments:

number1

What is the first number that we plan to divide?

Reference the cell that contains the first number:

=MOD(C9,

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:

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Cleaning Data with Excel’s REPLACE Formula What does it do?Replaces part of a text string, based on the number of characters you specify, with a different text stringFormula breakdown:=REPLACE(old_text, start_num, num_chars, new_text)What it means:=REPLACE(this cell, starting from this number, all the ...
Extracting Data with Excel’s RIGHT Formula What does it do?It returns the last character or characters in a text string, based on the number of characters you specify.Formula breakdown:=RIGHT(text, )What it means:=RIGHT(look in this cell, extract X characters)There are times when you will need ...
CountIfs Formula in Excel What does it do?Counts the number of cells that matches your specified conditionsFormula breakdown:=COUNTIFS(range1, criteria1, , , ...)What it means:=COUNTIFS(range of cells to check1, condition to check against1, , , ...)Do you have a scenario where ...
RANDBETWEEN Function for Excel Dates What does it do?Generates random dates, in between a start date and an end dateFormula breakdown:=RANDBETWEEN(bottom, top)What it means:=RANDBETWEEN(starting date for random date generation, end date for random date generation) If you need to ...