Exceljet

Quick, clean, and to the point

Excel MOD Function

Excel MOD function
Summary 

The Excel MOD function returns the remainder of two numbers after division.  For example, MOD(10,3) = 1. The result of MOD carries the same sign as the divisor.

Purpose 
Get the remainder from division
Return value 
The remainder
Syntax 
=MOD (number, divisor)
Arguments 
  • number - The number to be divided.
  • divisor - The number to divide with.
Version 
Usage notes 

Use the MOD function to get a reminder after division. For example, MOD(3,2) returns 1, because 2 goes into 3 once, with a remainder of 1.

Examples

Here are a few examples of the MOD function with hardcoded values:

=MOD(12,3) // returns 0
=MOD(12,5) // returns 2
=MOD(100,33) // returns 1
=MOD(6.25,1) // returns 0.25

Alternative formula

With very large numbers, you may see the MOD function return a #NUM error. In that case, you can try an alternative version based on the INT function:

=number-(INT(number/divisor)*divisor)

Notes

  • MOD is often seen in formulas that deal with "every nth" value
  • MOD is useful for extracting the time from a date
  • MOD always returns a result in the same sign as the divisor.
  • MOD will return a #DIV/0! error if the divisor is zero

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.

Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas