This function divides the two arguments passed and returns the remainder of the division. It differs from the Mod function of Excel, in the way the remainder is calculated.
= MODULUS(dividend, divisor)
Dividend |
A number which is being divided. The number can be specified as an integer (e.g., 37), as a decimal value (e.g., 37.48), as a string, or as the value of a variable (e.g, UnitPrice). |
Divisor |
A number which divides. The number can be specified as an integer (e.g., 37), as a decimal value (e.g., 37.48), as a string, or as the value of a variable (e.g, UnitPrice). |
Decimal number.
In the case of an error, the function displays an error message: “MODULUS (dividend, divisor): Error message”
The function can be used in combination with other functions.
Example |
Returns |
= MODULUS(-3.75, 2) |
-1.75 |
= MODULUS(-3, -2) |
-1 |
= MODULUS(“$3”, 2) |
1 |
= MODULUS(ExtendedPrice, Quantity) |
The remainder value of the division |
= MODULUS(2, 0) |
Displays message “MODULUS(2, 0): Attempted to divide by zero.” |
= MODULUS(FLOOR(UnitPrice), 2) |
The remainder of division between the floor value of UnitPrice and the number 2. |
= ABS(MODULUS(UnitPrice, 2)) |
The absolute value of the remainder got by division on floor value of UnitPrice by the number 2. |