Syntax
=MOD(dividend, divisor)
dividend- The number being divided.
divisor- The number to divide by.
MOD function in Google Sheets
MOD returns the remainder after dividing one number by another. Common uses are leftover minutes after whole hours, every-nth-row patterns, and odd/even checks.
Practice MOD
Task 1 of 1
Now find the minutes left over after the whole hours. Answer in C2.
Tip: while typing a formula, click a cell or drag across cells to insert references. Press Enter to check, and Tab to accept a function suggestion.
MOD examples
Each example below runs against this sample sheet. The results are calculated by the same engine as the practice grid.
| A | B | |
|---|---|---|
| 1 | Value | Other |
| 2 | -7.45 | 3 |
| 3 | 12.5 | 4 |
| 4 | 81 | 2 |
| 5 | 2.5 | 0 |
| 6 | 1234.567 | 5 |
| Formula | Result | What it shows |
|---|---|---|
=MOD(A4, B3) | 1 | Remainder of 81 ÷ 4. |
=MOD(A4, B4) | 1 | 0 means it divides evenly. Here 81 is odd, so the remainder is 1. |
=MOD(A4, B5) | #DIV/0! | Dividing by zero gives #DIV/0!. |
Tips and common mistakes
- In Google Sheets the result takes the sign of the divisor, so =MOD(-7, 3) is 2, not -1.
- =MOD(ROW(), 2) = 0 is a popular custom-formatting rule for shading every other row.
Related functions
Learning step by step? MOD is covered in Lesson 32: MEDIAN, MOD, ABS & More Math of the free course.