Mod Operator

Description

Used to divide two numbers and return only the remainder.

Syntax

result = number1 Mod number2

The Mod operator syntax has these parts:

Part

Description

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.


A = 19 Mod 6.7

Usually, the data type of result is a Byte, Byte variant, Integer, Integer variant, Long, or Variant containing a Long, regardless of whether or not result is a whole number. Any fractional portion is truncated. However, if any expression is Null, result is also Null. Any expression that is Empty is treated as 0.

Example

This example uses the Mod operator to divide two numbers and return only the remainder. If either number is a floating-point number, it is first rounded to an integer.


MyResult = 10 Mod 5            ' Returns 0.= 10 Mod 3            ' Returns 1.= 12 Mod 4.3        ' Returns 0.= 12.6 Mod 5        ' Returns 3.