This tip was printed from the Tips for Spreadsheets website at http://tipsforspreadsheets.com/.

Microsoft Excel 2003 Functions and Formulas - Return the Remainder of a Division Function

The =MOD Microsoft Excel 2003 function returns the modulus, or remainder, of a division function.

For example, if you divide 4 into 9, you get 2.25. Or, depending on how you look at numbers, you get a value of "2" with a remainder of "1" (9-(4*2) = 1).

The syntax:

=mod(NUMBER,DIVISOR)

* NUMBER is the number to divide (the left side of a division equation)

* DIVISOR is what you wish to divide the number by (the right side of a division equation)

For example, consider the following spreadsheet:

A1: =11/2
A2: =mod(11,2)

This will return the values:

A1: 5.5
A2: 1



Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2003 Functions and Formulas - Return the Remainder of a Division Function.
 
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.