Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.