The Excel MOD Function

Related Function:
QUOTIENT Function

Basic Description

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

The format 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 spreadsheets below show four simple examples of the Excel Mod function.

 Formulas:
 ABC
1=MOD( 6, 4 )
2=MOD( 6, 3 )
362.5=MOD( A3, B3 )
461.333=MOD( A4, B4 )
 Results:
 ABC
12
20
362.51
461.3330.668

Further details of the Excel Mod function can be found on the Microsoft Office website.