MODULUS function
Returns the remainder (modulus) resulting when a number is divided by a divisor. The result has the same sign as the divisor. A #DIV/0! error is returned if the divisor is 0.
Syntax
MODULUS(number,divisor)
Remarks
In almost all situations, the MODULUS function should be used rather than the MOD function.
Example 1
MODULUS(5, 1.4)
Returns 0.8.
Example 2
MODULUS(5, -1.4)
Returns -0.6.
Example 3
MODULUS(-5, 1.4)
Returns 0.6.
Example 4
MODULUS(-5, -1.4)
Returns -0.8.