You can use Excel MOD Function to get remainder after dividing two numbers.

In simple words, it will return remainder number which will be left after a division of two number.

Please note, it will not return the result of the division of two numbers but remainder. 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.

## More Information on Excel MOD Function

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

## Examples

In below example, I have use MOD with the different type 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

## What’s Next?

To learn more about Excel MOD Function you can check Microsoft’s Help Section.

And, if you have a unique idea to use the mod function, I would love to hear from you.

There are also you have INT function which is highly useful like mod function. Apart from this, I have a list of excel functions and some real life formulas examples.