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.
- number: a number which you want to divide.
- divisor: a number with which you want to divide.
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.
- It will return a #DIV/0! error if the divisor is zero.
- It always returns a result with the same sign as the divisor.