 # 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

## Example

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: