Total Subscribers Receiving Our Weekly Excel Lessons

+45,000

CLICK TO RECEIVE OUR FREE EXCEL LESSONS

Getting the remainder with Excel’s MOD Formula

Email this to someoneShare on FacebookTweet about this on TwitterShare on LinkedInShare on Google+

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:

Related Posts:

Clear Everything Before the Hyphen with Excel̵... What does it do? Replaces part of a text string, based on the number of characters you specify, with a different text string Formula breakdown: =REPLACE(old_text, start_num, num_chars, new_te...
Remove Second Hyphen with Excel’s SUBSTITUTE... What does it do? Substitutes new_text for old_text in a text string. Formula breakdown: =SUBSTITUTE(text, old_text, new_text, ) What it means: =SUBSTITUTE(This cell, By this text charac...
BETWEEN Formula in Excel There is no explicit Between formula in Excel, however we can come up with creative ways to create this functionality. Our goal is to evaluate if a given value is between a range, for example, is 6 be...
Change Phone Area Codes with Excel’s REPLACE Formu... What does it do? Replaces part of a text string, based on the number of characters you specify, with a different text string Formula breakdown: =REPLACE(old_text, start_num, num_chars, new_te...
Searching... Searching...

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!

Click here to subscribe

Leave a Comment

Your email address will never be published. Required fields are marked with *

Comments