# Mod operator

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.
```

## See also

### Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.