How to use Excel MOD Function

how to use excel mod function

Quick Intro

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 that 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, we have used 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 more about this tips

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 it, I would love to hear from you.

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



  • Ogundepo Ezekiel Adebayo

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

  • GraH

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