Spreadsheet formulas explained, side by side

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

AppSupportSyntax & notes
Excel✔ Built inMOD(number, divisor)
Google Sheets✔ Built inMOD(dividend, divisor)
Airtable✔ Built inMOD(value, divisor)
With negative numbers the sign of the result may follow the dividend (like JavaScript), not the divisor.
Notion✔ Built inmod(number, divisor)
Also written number % divisor. The result takes the sign of the dividend, so mod(-7, 3) is −1 where Excel gives 2.
Try MOD with your own values
Result (as Excel & Google Sheets return it)
1
Your formula, ready to paste
Excel=MOD(10, 3) open excel.new ↗
Google Sheets=MOD(10, 3) open sheets.new ↗
AirtableMOD(10, 3)
Notionmod(10, 3)

Arguments

ArgumentWhat it means
numberThe number to divide (dividend).
divisorThe number to divide by. 0 gives #DIV/0!.

Examples

FormulaResultWhyCopy
=MOD(10, 3)1
=MOD(-7, 3)2Excel and Sheets: the result has the sign of the divisor.
=MOD(ROW(), 2)=0TRUE on even rowsClassic conditional-formatting rule for zebra stripes.
=MOD(A2, 1)Time partThe 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 dedicated ISEVEN(A2) in Excel and Google Sheets.

Part of the Math & Rounding functions. Results in the tester follow Excel and Google Sheets behaviour; always double-check important work in your own file.