how to use excel mod functionYou 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.

Examples For Excel MOD Function

  1. If there is no remainder after dividing two numbers it will return zero.
  2. If there is a decimal in divisor it will consider that decimal and return result according to that.
  3. If you specify zero to divide, it will return 0 in the result. Dividing any number by zero results in zero.
  4. If 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 same as positive values and return same sign that divisor have.

Sample File

download sample file to learn about excel mod function

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.