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)

mod

Last Updated: