MODULUS Function
Returns the remainder (modulus) that results when a number is divided by a divisor.
Syntax
MODULUS(number,divisor)
Parameters
Name |
Required/Optional |
Data Type |
Description |
---|---|---|---|
number |
Required |
Number |
The dividend. |
divisor |
Required |
Number |
The divisor. |
Return Value
Number
Remarks
The result has the same sign as the divisor. A #DIV/0! error is returned if the divisor is 0.
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.