Excel MOD Function

HomeExcel FunctionsExcel MOD Function (Example + Sample File)

What is EXCEL MOD FUNCTION

The Excel MOD Function is listed under Microsoft Excel's Maths Functions category. It returns the remainder value after dividing a number with a divisor. In simple words, the MOD function returns that value which remains after the division of two numbers.

How to use it

To learn how to use the MOD function in Excel, you need to understand its syntax and arguments:

Syntax

MOD(number, divisor)

Arguments

  • number: The number which you want to divide.
  • divisor: The number with which you want to divide

Notes

  • It will return a #DIV/0! error if the divisor is zero.

Example

To master the MOD function we need to try it out in an example, so make sure to check out the below one:

In the below example, we have used MOD with the different types of values:

  1. If there is no remainder after dividing two numbers it returns zero.
  2. If there is a decimal in divisor it considers that decimal and returns result according to that.
  3. If you specify zero to divide, it returns a 0 in the result. Dividing any number by zero results in zero.
  4. If the divisor will zero, it will return #DIV/0!.
  5. If you skip specifying any number for dividing it will return 0 in the result.
  6. And if you skip specifying any divisor, it will return #DIV/0!.
  7. It will consider negative values and return the same sign that the divisor has.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.