Summary: Round numbers in your Microsoft Excel 2003 spreadsheets to the nearest dollar.
Need to round numbers, such as money, to the nearest integer (or dollar)? There are several Microsoft Excel 2003 formulas that can help in this task. This tip will discuss three of them.
1) The formula ROUNDDOWN rounds a number down to. The syntax:
=rounddown(NUMBER,NUMBER_OF_DIGITS)
Examples:
=rounddown(23.6,0)
23
=rounddown(21.99,0)
21
2) The formula ROUNDUP rounds a number up. The syntax:
=roundup(NUMBER,NUMBER_OF_DIGITS)
Examples:
=roundup(23.6,0)
24
=roundup(5.0000001,0)
6
3) The formula ROUND rounds a number up or down depending on the number. The syntax:
=roundup(NUMBER,NUMBER_OF_DIGITS)
Examples:
=round(23.6,0)
24
=round(8.4999999,0)
8
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: