Purpose
Get the remainder from division
Return value
The remainder
Syntax
=MOD (number, divisor)
Arguments
- number – The number to be divided.
- divisor – The number to divide with.
Usage notes
Use the MOD function to get the reminder after division. For Example, MOD(3,2) returns 1, because 2 goes into 3 once, with a remainder of 1.
Notes:
- MOD always returns a result in the same sign as the divisor.
- MOD will return a #DIV/0! error if the divisor