Summary: Display the remainder of a division function in Excel.
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
Add: Del.icio.us |
Digg |
Furl |
My Yahoo!
Last Modified on: July 13, 2008, at 12:04 A.M. EDT
Return to the Microsoft Excel 2003 Functions and Formulas page.
Search the Site: