Excel: Mod Function

In Excel, the Mod function returns the remainder after a number is divided by a divisor.

The syntax for the Mod function is:

Mod( number, divisor )

number is a numeric value whose remainder you wish to find.

divisor is the number used to divide the number parameter. If the divisor is 0, then the Mod function will return the #DIV/0! error.

Applies To:

For example:

Let's take a look at an example:

Based on the Excel spreadsheet above:

=Mod(A1, A2) would return 2

=Mod(A1, A3) would return -7

=Mod(34, A2) would return 0

=Mod(34, 0) would return #DIV/0!