MOD Function in Excel, Google Sheets, Airtable & Notion
MOD returns the remainder after dividing one number by another. MOD(10, 3) is 1 because 10 = 3 × 3 + 1.
Syntax in each app
| App | Support | Syntax & notes |
|---|---|---|
| Excel | ✔ Built in | MOD(number, divisor) |
| Google Sheets | ✔ Built in | MOD(dividend, divisor) |
| Airtable | ✔ Built in | MOD(value, divisor)With negative numbers the sign of the result may follow the dividend (like JavaScript), not the divisor. |
| Notion | ✔ Built in | mod(number, divisor)Also written number % divisor. The result takes the sign of the dividend, so mod(-7, 3) is −1 where Excel gives 2. |
| Excel | =MOD(10, 3) | open excel.new ↗ |
|---|---|---|
| Google Sheets | =MOD(10, 3) | open sheets.new ↗ |
| Airtable | MOD(10, 3) | |
| Notion | mod(10, 3) |
Excel & Sheets use cell ranges. Paste this sample data into cell A1 of a blank sheet, then paste the formula into any empty cell.
Arguments
| Argument | What it means |
|---|---|
number | The number to divide (dividend). |
divisor | The number to divide by. 0 gives #DIV/0!. |
Examples
| Formula | Result | Why | Copy |
|---|---|---|---|
=MOD(10, 3) | 1 | ||
=MOD(-7, 3) | 2 | Excel and Sheets: the result has the sign of the divisor. | |
=MOD(ROW(), 2)=0 | TRUE on even rows | Classic conditional-formatting rule for zebra stripes. | |
=MOD(A2, 1) | Time part | The fraction of a date-time value. |
Examples use Excel / Google Sheets syntax unless noted.
How MOD works
MOD is the spreadsheet version of the % operator. Typical uses: testing whether a number is even (=MOD(A2, 2)=0), highlighting every third row, converting minutes into “hours and minutes” (=INT(A2/60) hours and =MOD(A2, 60) minutes) and wrapping values around a cycle such as days of the week.
Negative numbers are where apps disagree. Excel and Google Sheets return a result with the sign of the divisor: MOD(−7, 3) = 2, because −7 = 3 × (−3) + 2. Notion (and JavaScript-based formulas generally) keep the sign of the dividend and return −1. If you need Excel's behaviour in Notion, use mod(mod(n, d) + d, d).
Frequently Asked Questions
- How do I check if a number is even?
- Use
=MOD(A2, 2)=0, or the dedicatedISEVEN(A2)in Excel and Google Sheets.