Description | The |
Syntax | MOD( |
Output | number |
Variables
dividend
: The number to be divided.divisor
: The number by which the dividend is divided.
Example
MOD(`Quantity Sold - NY`,100)
Product | Price (USD) | Quantity Sold - NY | MOD |
Product A | 25.99 | 150 | 50 |
Product B | 14.75 | 280 | 80 |
Product C | 7.99 | 500 | 0 |
Product D | 35.20 | 90 | 90 |
Product E | 50.00 | 120 | 20 |