**Table of Content**Close

MOD is a part of Excel’s Maths Functions. It **returns the remainder value after dividing a number with a divisor**. In simple words, it returns that value that remains after the division.

## Syntax

MOD(number, divisor)

## Arguments

**number**: a number which you want to divide.**divisor**: a number with which you want to divide.

## Example

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 the divisor it considers that decimal and returns the 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.

## Important Points

- It will return a #DIV/0! error if the divisor is zero.
- It always returns a result with the same sign as the divisor.