Excel Math Functions : MOD

Introduction to MOD Function

MOD function returns the remainder value after dividing a number with a divisor. In simple words, it returns that value which remains after the division of two numbers.

Download Sample file

Download Sample file for working with the tutorial.

Syntax of MOD Function

MOD(number, divisor)

Arguments in MOD Function

• number: The number which you want to divide.
• divisor: The number with which you want to divide

Notes

• It will return a #DIV/0! error if the divisor is zero.

Tutorial of MOD Function in MS Excel

In the below example, we have used MOD with the different types of values:

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

Other Math Function in Microsoft Excel

Explore other math function in Microsoft excel. The list of all the math function available for everyday use is given below –

• ABS Function
• EVEN Function
• INT Function
• MOD Function
• MROUND Function
• RAND Function
• SUM Function
• SUMIF Function
• SUMIFS Function
• SUMPRODUCT Function
• TRUNC Function