Divides two numbers and returns only the remainder.

result = number1 Mod number2

Arguments

result

Any numeric variable.

number1

Any numeric expression.

number2

Any numeric expression.

Remarks

The modulus, or remainder, operator divides number1 by number2 (rounding floating-point numbers to integers) and returns only the remainder as result. For example, in the following expression, A (which is result) equals 5.

Copy Code

A = 19 Mod 6.7

If any expression is Null, result is also Null. Any expression that is Empty is treated as 0.