Excel ROUND function: YOUR OBJECTIVE
For statistical purposes, you’ve been asked to calculate your company’s average production (manufactured units) over a period of several weeks. At first, when making this calculation, you obtain a numerical result with several decimals places to the right of the decimal point. Since those extra decimal places contribute nothing to one’s understanding, you want to round this result.
In this learning module, you will be shown how to use Excel’s ROUND function to automatically round numbers.
HOW DOESTHE EXCEL ROUND FUNCTION WORK?
To round the numerical contents of a cell or the value resulting from a calculation, use the ROUND function from the Math & Trig category.
First select the cell that is to contain the result, in our example, cell F3. Then start the function wizard by clicking the button just to the left of the formula bar. Now look up the excel ROUND function and click OK.
The excel ROUND function requires two arguments:
- the number that is to be rounded.
- the number of digits that are to appear (rounded) after the decimal point.
The “Number” argument can be a cell reference. Enter the cell reference by clicking in the cell containing the value to be rounded.
It is also possible to use a cell reference for the second argument “Num_digits”, but it is seldom that the number of rounded decimal places is intended to vary. This argument, therefore, is generally entered as a fixed number. Type into the input box the number of decimal places you want to appear (rounded) after the decimal point.
The “Number” argument does not have to be a cell reference but can also be a formula or another function.
If you enter a cell reference pointing to cell E3 as the Number argument and the number 0 for the “num_digits” argument, your results will look like this:
Whenever a cell with a function is selected, the complete function is displayed in the formula bar, as in the current example:
The formula can be read like this: Display the value of cell E3, rounded to 0 decimal places after the decimal point.
Not apparent at first glance is a special feature of this function: You can also use it to round numbers to the left of the decimal point as well. By entering negative numbers for the “num_digits” argument, you can round the result to the nearest tens or hundreds, and so on. The number 2,456, for example, when rounded with a num_digits of -1, would produce a result of 2,460. Rounding that same number with a num_digits of -2, would produce a result of 2,500.