Excel Function: MOD

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:

1. If there is no remainder after dividing two numbers, it returns zero.
2. If there is a decimal in the divisor it considers that decimal and returns the 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.

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.