MOD
Formula Explanation
The MOD function calculates the remainder after dividing two numerical expressions.
Formula Syntax
Result column input: mod(dividend / column number, divisor / column number)
- Both parameters can be data columns, i.e., the CODE at the top of each column in the table, e.g., AA1.
Usage Example
Calculate the remainder of the values in column DR2 divided by the values in column DR3. Write the result in column DR4.
DR4 = mod(DR2,DR3)