The MOD function returns the remainder after dividing two numbers.
In simple words, it returns the remainder number which left after the division of two number.
For example, by dividing 3 and 2 you will get 1 in return.
- 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 will return zero.
- If there is a decimal in divisor it will consider that decimal and return result according to that.
- If you specify zero to divide, it will return 0 in the result. Dividing any number by zero results in zero.
- If 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 same as positive values and return same sign that divisor have.
- It always returns the remainder with the same sign as divisor have.