Returns the modulus of one number divided by another. The modulus is the remainder of the division of the dividend by the divisor. The sign of the remainder always equals the sign of the dividend.
Note: The following expressions are examples of using the Mod function:
The first occurrence of X is used as the dividend and the tenth occurrence of Y is used as the divisor. The first fifth occurrence of Value rounded to two decimal places is used as the dividend and the highest of all non-null occurrences of Value is used as the divisor.