Home

Microsoft Excel [email protected]

Microsoft Excel 2007

Microsoft Excel 2003

Forums

Microsoft Excel 2003 Functions and Formulas

Round Numbers to the Nearest Integer

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.

Print this tip.

- Subscribe!

Search the Site: