Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
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.