Excel MOD function: how to calculate remainder of Division with Excel formula


How to use the excel MOD function to get the remainder of the division of a number in microsoft excel.

Examples and how to use the Excel mode function

Excel function mode

Excel mode formulas – Mathematically, in the division of numbers not all numbers can be divisible by the divisor number. For example, if we divide the number 10 by the number 3, it will result in a value of 3 and still the remaining 1 to be divided by 3. In the form of a fraction 10/3 = 3 1/3.

Other examples:

  1. 15/2 will leave the number 1.
  2. 20/3 will leave the number 2
  3. 25/5 will leave the number 0 or no remainder.

In microsoft excel, to get the remainder of this division is relatively easier, because excel already provides a special excel function that can be used to compile a certain excel formula to calculate the remainder of the division of a number value, namely by using the MOD function.

Uses mode function in excel is to get the residual value of the division of a number.

Then how to use this excel MOD function? Next let’s learn how to use this MOD function in excel formulas.

Before continuing the discussion about the MOD function or formula, if you intend to get the value in front of the comma on the number/decimal value can be learned on the following page: Excel Formulas Omit Numbers Behind Commas.

Meanwhile, to get the value behind the comma can be done by reducing the decimal number to the value of the number in front of the comma described in the link above.

How to use Excel mode functions

In excel formula writing MOD function follows the following rules:

MOD(NilaiAngka; NilaiPembagi)

From the syntax above this MOD function has two argument parameters that must be filled.

Nilai Nangka
Represents the value of the number to be divided.
Value divisor
is the number that will divide Nilai Nangka.

Excel MOD Formula example

Consider an example of using the MOD function in an excel formula to get the following remainder of the division:

Excel MOD Formula example

Further explanation of the examples of using the MOD formula above is as follows.


The excel formula above will produce the number 3, which is the remainder of dividing the number 13 by the number 5.


In the formula above argument or parameter function MOD using cell reference where the value of B3 is 15 and the value of C3 is 2. The remainder of the division of 15 by the number 2 is 1 as seen in example number 2 upstairs.

Likewise with example number 3 who uses excel formulas:


The formula above will produce the value of the number 2, which is the remainder of the number 20 divided by the number 3.

If in the division of numbers there is no waste then the MOD function will meghasilkan value 0, as seen in example number 4, where the number 30 is divisible by the number 10 and leaves no division.

When the value divisor is greater than the divided value then the MOD function on the excel formula will generate the divided number itself (see example number 5).

Also note, when using the MOD function that the divisor value cannot be 0 (zero) or blank (blank).

If the divisor parameter is 0 (zero) or blank (empty), then the excel MOD function will generate an error value #DIV/0! as seen on example number 6.

Well pretty easy isn’t it? So long ago we talked about how to use excel’S MOD function to get the remainder of the division.

After reading the explanation above, maybe you are interested in learning how to round numbers in excel. You can find this Tutorial on rounding numbers in excel on the following page : Number rounding formula in excel.

May be useful.

Thanks for visit my blog!

Related Posts

Leave a Reply

Your email address will not be published.

Please Wait