Mod Operator

Mod Operator

---

Syntax

   result   =   number1   Mod   number2   

number1, number2 (required; any)

A numeric expression

Return Value

Returns the modulus

Description

Returns the modulus, that is, the remainder when number1 is divided by number2 . This return value is a non-negative integral data type.

Rules at a Glance

• Floating point numbers are rounded to integers before the division.

• If number1 or number2 is Nothing , then an error occurs.

• The Mod operator returns the data type of number1 and number2 if they are the same type, or the widest data type of number1 and number2 if they are different.

Example

 MsgBox(10 Mod 3)   ' returns 1