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.

## Syntax

MOD(number, divisor)

*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 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.

## Sample File

Download this sample file from here to learn more.

## Remember

- It always returns the remainder with the same sign as divisor have.

Smart one. Used MOD before, but never thought of this.

Thanks for the teaching. I’m glad I have you as my teacher. Ezekiel from Nigeria.