Mod
The Mod (modulus) function computes the remainder of a division operation, dividing the first value by the second value.
Syntax
Mod(x, y)
Function arguments:
xRequiredThe dividend; the value that is divided.yRequiredThe divisor; the value that is divided by.Non-zero.
Examples
Mod(19,5)=4
19 divided by 3 has the modulus of 4.
Div(2,3)=0
2 divided by 3 has the modulus of 2.
Mod([X],[Y])
The Mod function returns the following values for the X and Y columns: