The Excel MOD Function

Home » Excel-Built-In-Functions » Excel-Mod-Function

Search this site:

Custom Search

Related Function :

QUOTIENT Function

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.

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.

Formulas
Examples of use of the Excel Mod Function