What is MOD function in Excel?
MOD function is one of the Math and Trig functions in Microsoft Excel that returns the remainder after number is divided by divisor. The result has the same sign as divisor.
Syntax of MOD function
The MOD function syntax has the following arguments:
- Number: The number for which you want to find the remainder.
- Divisor: The number by which you want to divide number.
MOD formula explanation
- If divisor is 0, MOD returns the #DIV/0! error value.
- The MOD function can be expressed in terms of the INT function:
MOD(n, d) = n – d*INT(n/d)
Example of MOD function
Steps to follow:
1. Open a new Excel worksheet.
2. Copy data in the following table below and paste it in cell A1
Note: For formulas to show results, select them, press F2 key on your keyboard and then press Enter.
You can adjust the column widths to see all the data, if need be.
|=MOD(3, 2)||Remainder of 3/2||1|
|=MOD(-3, 2)||Remainder of -3/2. The sign is the same as divisor||1|
|=MOD(3, -2)||Remainder of 3/-2. The sign is the same as divisor||-1|
|=MOD(-3, -2)||Remainder of -3/-2. The sign is the same as divisor||-1|