MOD function

Syntax

MOD(number,divisor)

General remarks

The MOD function can be expressed in terms of the INT function:

=number-divisor*INT(number/divisor)

Example

To make the following example easier to understand, you can copy the data to a blank sheet and then enter the function underneath the data. Do not select the row or column headings (1, 2, 3... A, B, C...) when you copy the sample data to a blank sheet.

1 2 3 4 5

A B Formula Description (Result) =MOD(3,2) Remainder of 3/2 (1) =MOD(-3,2) Remainder of -3/2. The sign is the same as divisor (1) =MOD(3,-2) Remainder of 3/-2. The sign is the same as divisor (-1) =MOD(-3,-2) Remainder of -3/-2. The sign is the same as divisor (-1)