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

Microsoft Excel 2003 Functions and Formulas - Round Numbers to the Nearest Integer

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



Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2003 Functions and Formulas - Round Numbers to the Nearest Integer.
 
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.