MOD Excel formula – Mathematically, in the division of numbers not all numbers can be divisible by the divisor. For example, if we divide the number 10 by the number 3, it will produce a value of 3 and there is still 1 left to divide by 3. In the form of a fraction 10/3 = 3 1/3.
Another example:
15/2 will leave the number 1.
20/3 will leave 2
25/5 will leave 0 or no remainder.
In Microsoft Excel, getting the remainder of this division is relatively easy, because Excel has provided 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.
The use of the MOD function in excel is to get the remainder 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 in a number/decimal value, you can study on the following page: Excel Formulas Eliminate Numbers Behind Commas.
Meanwhile, getting the value behind the comma, it can be done by subtracting the decimal number from the number in front of the comma described in the link section above.
How to Use Excel’s MOD Functions
In the excel formula for writing the MOD function, it follows the following rules:
Code:
MOD(NumberValue;DividerValue)
From the above syntax, this MOD function has two parameter arguments that must be filled.
- Score
Is the value of the number to be divided.
- ValueDivider
is the number that will divideNumberValue .
Excel MOD Formula Example
Consider an example of using the MOD function in an excel formula to get the following division result:
Further explanation of the examples of using the MOD formula above is as follows.
Code:
=MOD(13;5)
The excel formula above will produce the number 3, which is the remainder of dividing the number 13 by the number 5.
Code:
=MOD(B3;C3)
In the above formula, the arguments or parameters of the MOD function use cell references 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 shown in the example number 2 above.
Likewise with example number 3 which uses the excel formula:
Code:
=MOD(B4;C4)
The formula above will produce the number 2, which is the remainder of the number 20 divided by the number 3.
If there is no remainder in the division of numbers, the MOD function will return a value of 0, as seen in example number 4 , where the number 30 is divisible by the number 10 and leaves no division.
If the divisor value is greater than the divided value, the MOD function in the excel formula will produce the divided number itself (see example number 5 ).
It should also be noted, when using the MOD function that the value of the divisor cannot be 0 (zero) or empty (blank).
If the divisor parameter is 0 (zero) or blank (Empty), then the Excel MOD function will return an error value of #DIV/0! as seen in example number 6.
Well it’s pretty easy, isn’t it? That’s it for our discussion on 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 about how to round numbers in excel. You can find a tutorial on rounding numbers in excel on the following page: Formula for rounding numbers in excel
