MOD Function Generator
MOD returns the remainder after one number is divided by another. Common uses: alternating row colors, detecting multiples, splitting hours from minutes.
Syntax
=MOD(number, divisor)Try it — generate a MOD formula
Examples
Is number even?
=MOD(A2, 2)=0Remainder 0 when divided by 2 means even.
Every 5th row
=MOD(ROW(), 5)=0Useful for conditional formatting highlights.
Minutes from total seconds
=MOD(A2, 60)A2 = total seconds. Remainder after dividing by 60 = leftover seconds.
Tips
- ✓MOD returns sign matching the divisor (Excel).
- ✓For negative numbers, behavior matches Excel: MOD(-3, 2) = 1.
- ✓Pair with ROW() and conditional formatting for striped tables.
Related Formulas
POWER
POWER raises a number to the power of an exponent. Equivalent to using ^ but mor...
ROUND / ROUNDUP / ROUNDDOWN
Three rounding functions: ROUND (nearest), ROUNDUP (always up), ROUNDDOWN (alway...
CEILING / FLOOR
CEILING rounds up to the nearest multiple of a given number; FLOOR rounds down. ...
Need a different formula?
Describe any formula in plain English and FormulaPad will generate it.
Try FormulaPad Free