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 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.

 Formulas:
Examples of use of the Excel Mod Function
 Results:
Excel Mod Function Results
Return to the Excel Math Functions Page

Return to the List of All Built-In Excel Functions

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2014 ExcelFunctions.net