This Excel tutorial explains how to use Excel MOD Function to get remainder in division.
Excel MOD Function to get remainder
In Excel worksheet, you can calculate quotient by a division using operator / . However chances are you need to calculate the quotient as well as reminder. Excel MOD Function calculate the remainder.
Syntax of Excel MOD Function
|The number for which you want to find the remainder
|The number by which you want to divide number
Example of Excel MOD Function
|Remainder of 10/3 = 1
|Note that negative number does not work as expected because of how the function handles negative number
|To handle negative number, use ABS Function on the negative number before using MOD Function
You can get the quotient using INT Function.