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 |
Required; any numeric variable. |

number1 |
Required; any numeric expression. |

number2 |
Required; 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 (*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 **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.

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