MOD Function in excel and how does it work?

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.

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: