MOD

Using the Excel MOD Function

Summary

The Excel MOD function returns the remainder after a given number is divided by the divisor. The output will have the same sign as the divisor.

Syntax

=MOD (number, divisor)

Syntax Breakdown

number
The number argument is required and is the number for which you would like to find the remainder.

divisor
Divisor is also required and is the number by which you would like to divide.


Usage Notes

The MOD function returns the remainder of two numbers after they are divided. The output will have the same sign as the divisor argument. If divisor is zero (0), the function will return the #DIV/0! error.

Excel MOD DIV Error