The MOD function is one of the very important mathematical function which is going to be used a lot and it can be very helpful sometimes.
The MOD FUNCTION is found under the MATH AND TRIG category of functions in Microsoft EXCEL.
THE MOD FUNCTION SIMPLY RETURN THE REMAINDER AFTER DIVIDING ANY GIVEN NUMBER WITH THE GIVEN DIVISOR.
The MOD FUNCTION can be used in conjunction with other functions to get many tricks done.
In this article, we would learn all aspects of the MOD FUNCTION, its purpose, usage etc. with the help of the examples.
PURPOSE OF MOD FUNCTION IN EXCEL
MOD FUNCTION returns the remainder of a division process where we have the number and the divisor.
It means, let us assume that we want to divide 5 by 2.
5 is the dividend and 2 is the divisor.
The result given by the MOD FUNCTION will be 1. [ 5/2 = 2 as quotient and 1 as remainder ]
The MOD FUNCTION is very useful in the situations where we need to find out the remainder of any division such as finding out the multiples of any number, to verify a complete division etc.
PREREQUISITES TO LEARN MOD FUNCTION
THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.
- Basic understanding of how to use a formula or function.
- Basic understanding of rows and columns in Excel.
- The basic division process.
- Of course, Excel software.
Helpful links for the prerequisites mentioned aboveWhat Excel does? How to use formula in Excel?
TERMS OF DIVISION PROCESS IN MATHS
The DIVISION is basic process which is taught in early school.
We are just going to remind the terms of the division which are sometimes confusing.
Suppose, we have the following division.
69 ÷ 2 = 34 as quotient and 1 as remainder
69 is dividend and 2 is the divisor.
SYNTAX: MOD FUNCTION
The Syntax for the MOD function is
=MOD ( THE NUMBER TO BE DIVIDED, THE DIVIDING NUMBER ) or MOD (DIVIDEND , DIVISOR )
DIVIDEND is the number to be divided.
DIVISOR is the number, which is dividing.
EXAMPLES : MOD FUNCTION IN EXCEL
find the remainders after dividing the first number from the second number
The following data is given to us in which we need to find out the remainder after dividing the first number from the second.
The following picture shows the number and the divisor.
STEPS TO FIND THE REMAINDER OF THE DIVISION GIVEN IN THE EXAMPLE:
- Select the cell where you want to get the result. For our example, we selected G5 as we want the result in that cell.
- Put the formula as =MOD ( E5, F5 ).
- Press ENTER.
- The result will appear in the cell.
- Similarly we can get the result for all the examples.
The formula used is
=MOD ( E5 , F5 )
The first argument E5, is the address of the cell which contains the number to be divided.
F5 , which is the second argument, contains the number which is the divisor, which is dividing the number present in the E5 .
Similarly, all the formulas used are given in the last column of the examples.