MOD Function in Excel: Syntax, Examples and Free Practice

By Rinkesh Shah, founder of Cellgrids.

MOD is an Excel Math & Trig function. Returns the remainder after dividing one number by another.

MOD syntax

=MOD(number, divisor)

MOD is used in financial models and engineering-style calculations where precise numeric work is needed.

Open the live Excel-style spreadsheet and try MOD yourself. No Excel install or sign-up needed to start.

What does the MOD function do in Excel?

Returns the remainder after dividing one number by another.

What is the syntax of MOD in Excel?

The syntax is =MOD(number, divisor). number: A number to use in the calculation; divisor: The number to divide by.

Where can I practice MOD online for free?

Open the free live spreadsheet on Cellgrids and try MOD yourself. No Excel install is needed and you can start without signing up.