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.