This documentation is archived and is not being maintained.
MODULUS Function
MODULUS(number,divisor)
Parameters
|
Name
|
Required/Optional
|
Data Type
|
Description
|
|
number
|
Required
|
Number
|
The dividend.
|
|
divisor
|
Required
|
Number
|
The divisor.
|
Return Value
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.
MODULUS(5, 1.4)
Returns 0.8.
MODULUS(5, -1.4)
Returns -0.6.
MODULUS(-5, 1.4)
Returns 0.6.
MODULUS(-5, -1.4)
Returns -0.8.