Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

MOD function: Description, Usage, Syntax, Examples and Explanation

What is MOD function in Excel?

MOD function is one of the Math and Trig functions in Microsoft Excel that returns the remainder after number is divided by divisor. The result has the same sign as divisor.

Syntax of MOD function

MOD(number, divisor)

The MOD function syntax has the following arguments:

  • Number: The number for which you want to find the remainder.
  • Divisor: The number by which you want to divide number.
Worked Example:   Sum every nth column in Excel

MOD formula explanation

  • If divisor is 0, MOD returns the #DIV/0! error value.
  • The MOD function can be expressed in terms of the INT function:

MOD(n, d) = n – d*INT(n/d)

Worked Example:   Basic timesheet formula with breaks in Excel

Example of MOD function

Steps to follow:

1. Open a new Excel worksheet.

2. Copy data in the following table below and paste it in cell A1

Note: For formulas to show results, select them, press F2 key on your keyboard and then press Enter.

You can adjust the column widths to see all the data, if need be.

Worked Example:   Add decimal minutes to time in Excel
Formula Description Result
=MOD(3, 2) Remainder of 3/2 1
=MOD(-3, 2) Remainder of -3/2. The sign is the same as divisor 1
=MOD(3, -2) Remainder of 3/-2. The sign is the same as divisor -1
=MOD(-3, -2) Remainder of -3/-2. The sign is the same as divisor -1

Leave a Reply

Your email address will not be published. Required fields are marked *