Tips for Spreadsheets

*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: