MOD Function Explained
The MOD()
function in Microsoft Excel returns the remainder of a division operation. It takes two arguments: a dividend and a divisor. It returns the remainder of the dividend divided by the divisor. For example, MOD(10,3)
returns 1, since 10 divided by 3 is 3 with a remainder of 1.
MOD Function Syntax
MOD(number, divisor)
- number: The number for which you want to find the remainder.
- divisor: The number by which you want to divide number.