Using AutoSum for Quick Calculations in Excel 2007
Crunching Numbers with Excel 2007's AVERAGE, MAX, MIN, and MEDIAN Functions
Using Excel 2007's IS Information Functions

Rounding Numbers in Excel 2007 with ROUND, ROUNDUP, and ROUNDDOWN

The mathematical functions ROUND, ROUNDUP, and ROUNDDOWN are included in the Math & Trig category in Excel 2007. You'll find these by clicking the Math & Trig button on the Ribbon’s Formulas tab or in the Select a Category list in the Insert Function dialog box.


You use the ROUND function to round up or down fractional values in the worksheet as you might when working with financial worksheets that only need to show monetary values to the nearest dollar. Unlike when applying a number format to a cell, which affects only the number’s appearance, the ROUND function actually changes the way Excel stores the number in the cell that contains the function. ROUND uses the following syntax:


In this function, the number argument is the value that you want to round off, and num_digits is the number of digits to which you want the number rounded. If you enter 0 (zero) as the num_digits argument, Excel rounds the number to the nearest integer. If you make the num_digits argument a positive value, Excel rounds the number to the specified number of decimal places. If you enter the num_digits argument as a negative number, Excel rounds the number to the left of the decimal point.


Instead of the ROUND function, you can use the ROUNDUP or ROUNDDOWN function. Both ROUNDUP and ROUNDDOWN take the same number and num_digits arguments as the ROUND function. The difference is that the ROUNDUP function always rounds up the value specified by the number argument, whereas the ROUNDDOWN function always rounds the value down.

The figure illustrates the use of the ROUND, ROUNDUP, and ROUNDDOWN functions in rounding off the value of the mathematical constant pi. Cell A3 contains the value of this constant (with just nine places of nonrepeating fraction displayed when the column is widened) into this cell, using Excel’s PI function in the following formula:


The ROUND, ROUNDUP, and ROUNDDOWN functions in the cell range B3:B10 round this number up and down to various decimal places.

Rounding off the value of pi with the ROUND, ROUNDUP, and ROUNDDOWN functions.
Rounding off the value of pi with the ROUND, ROUNDUP, and ROUNDDOWN functions.

Cell B3, the first cell that uses one of the ROUND functions to round off the value of pi, rounds this value to 3 because 0 (zero) is specified as the num_digits argument of its ROUND function (causing Excel to round the value to the nearest integer).

Note the difference between using the ROUND and ROUNDUP functions both with 2 as their num_digits arguments in cells B5 and B7, respectively. In cell B5, Excel rounds the value of pi off to 3.14, whereas in cell B7, the program rounds its value up to 3.15. Note that using the ROUNDDOWN function with 2 as its num_digits argument yields the same result, 3.14, as does using the ROUND function with 2 as its second argument.

blog comments powered by Disqus
Determining Cell Data Types with Excel 2007's TYPE Function
Deconstructing Dates in Excel 2007 with DAY, WEEKDAY, MONTH, and YEAR
Planning Ahead with Excel 2007's TODAY, DATE, and DATEVALUE Functions
How to Join Text Strings in Excel 2007 with the & Operator
Simplifying Numbers with Excel 2007's INT and TRUNC Functions