The Excel MOD Function

Related 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 divides the number argument.

These arguments can be supplied to the function either as simple numbers, as references to cells containing numbers, or as values returned from other functions. This is shown in the examples below.

Excel Mod Function Examples

The following spreadsheets show simple examples of the Excel Mod function. The format of the function is shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right.

Examples of use of the Excel Mod Function
Excel Mod Function Results