# 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: 