Excel MOD Function: Understanding its Use and Functionality

Last updated on July 7th, 2024 at 12:39 am

What is the Mod Function?

The MOD Function is categorized under Excel Math and Trigonometry functions. This function helps find a remainder after a number(dividend) is divided by another number(divisor). It can be used as a worksheet function in Excel. As a worksheet function, the MOD function can be entered as a part of the formula in the cell of a worksheet.

Understanding the MOD Function in Excel

The MOD function in Excel, categorized under Math and Trigonometry functions, is indispensable for calculating remainders after division. This function is pivotal in various scenarios, such as determining periodic patterns or identifying specific data subsets within a dataset. As a versatile worksheet function, MOD operates efficiently across all versions of Excel, enabling users to integrate it seamlessly into formulas for enhanced data manipulation.

How does the MOD function work?

  • Syntax:

         MOD( number, divisor)

  • Parameters:
  1. Number – A numeric value whose remainder you wish to find.
  2. Divisor – The number used to divide the If the divisor is 0, it will return #DIV/0! Error.
  • Returns:

          The MOD function returns a numeric value.

  • Applies to:

          Excel for Office 365, Excel 2019, Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003,                Excel XP, Excel 2000


Suppose we are given the following data:

In the above data, we used the following formula:

The results we get in Excel are shown below: