Microsoft Excel provides plenty of built-in functions and formulas for performing mathematical calculations. Sometimes, we want to perform division operations and get the remainder. In order to do it manually, we can use the MOD function. This function will help you get the remainder as quickly as possible.
This article will let you know how to use the Excel MOD function in the spreadsheet. Get an official version of MS Excel from the following link:
What is the MOD Function?
MOD is one of the built-in functions in Microsoft Excel. It comes under Math functions. We can use this function in our spreadsheet whenever we want to get the remainder by performing division operations.
- This is the basic syntax of the Excel MOD Function.
- number – The input number to be divided.
- divisor – The number by which you want to divide the number.
- This function gets the remainder from the division.
4) Return Value
- It returns the remainder.
1) If the divisor is 0, it returns #DIV/0! Error value.
2) You can calculate MOD manually by using the below formula.
3) “n – d * INT (n/d)” where n is a number, d is a divisor.
What Will MOD Function Do?
As we said earlier, the MOD function will return the remainder of the two numbers after division. The result has the same sign as the divisor. This function is categorized as “Math” in Excel. Let’s see an example scenario to make you understand it easily.
Step 1: Here, we have come up with a set of integer values and divisors. We need to perform division and get the remainder as output. For that, we can use the MOD function.
Step 2: Now, we need to apply the following formula in any cell where we want to get the result.
Step 3: Now, click on the Enter button to get the result.
Step 4: To fill down the remaining cells, you just drag down the first cell. It will auto-fill the remaining cells as shown in the below screenshot.
We hope that the given scenario helped you to understand the MOD function. Move to the below section if you have any confusion related to the working nature of this function.
Here we will see how to apply the MOD function in the spreadsheet with simple examples.
1) Suppose you want to get the remainder by performing a division operation with two specific numbers, then you can directly apply it to the formula.
2) For example, we want to divide 100 by 30. We can apply the following formula in a cell where we want the result.
3) Hit the Enter button to get the result, as shown in the below image.
By doing so, you can quickly get the remainder by performing division with the help of the MOD function.
Input that Causes Error
By seeing the below-given example, you will understand the input that causes errors in the spreadsheet. If the divisor is 0, it returns #DIV/0! Error value.
To understand the usage of the MOD function, we have referred to the following articles. They helped us to know the purpose of this function. You can also check them out using the links: MOD function, and What is MOD?.
With the help of the given scenarios and examples, you can easily understand the purpose of the MOD function in Excel and how to apply it in the spreadsheet. The screenshots help to learn it even easier. Drop your feedback in the below comment section. Thanks for visiting AawExcel. Keep Learning!!
If you want to know what people think about this MOD Function of Excel, then we suggest you look for it on the Quora interaction webpage. From there you can get to know more about the Excel MOD function. Here, we have provided the link to Quora’s official website.
The following video will show you how to use the Excel MOD function in the spreadsheet with proper examples.
- How to Use Excel FLOOR.MATH Function?
- How to Use Excel FLOOR Function?
- How to Use Excel CEILING.PRECISE Function?
- How to Use Excel CEILING Function?
- How to Use Excel GCD Function?