The Excel MOD Function

Related Function:
QUOTIENT Function

Function Description

The Excel MOD function returns the remainder of a division between two supplied numbers.

The syntax of the function is:

MOD( number, divisor )

where the arguments are as follows:

number - The number to be divided.
divisor - The value that the number argument is divided by.

Excel Mod Function Examples

The spreadsheet below shows four simple examples of the Excel Mod function.

 Formulas:
  A B C
1 =MOD( 6, 4 )
2 =MOD( 6, 3 )
3 6 2.5 =MOD( A3, B3 )
4 6 1.333 =MOD( A4, B4 )
 Results:
  A B C
1 2
2 0
3 6 2.5 1
4 6 1.333 0.668

For further details of the Excel Mod function, see the Microsoft Office website.


Mod Function Errors

If you get an error from the Excel Mod function this is likely to be one of the following:

Common Errors
#DIV/0! - Occurs if the supplied divisor argument is zero.
#VALUE! - Occurs if any of the supplied arguments are non-numeric.