# Excel MOD Function

Home ➜ Excel Functions List (Top 100) Examples + Sample File ➜ **Excel 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:

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

**Hey Listen,**

Check out this Microsoft Excel Guide to learn some of the basics of Excel, and from here, you can find Top Excel Tips and Tricks to get to an advanced level.

## 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 ﬁnd him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.

COPYRIGHT © 2020 • EXCEL CHAMPS