Returns the remainder after number is divided by divisor. The result has the same sign as divisor.
The number for which you want to find the remainder.
The number by which you want to divide number.
The MOD function can be expressed in terms of the INT function:
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.