**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.

**HINT**

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.

**HINT**

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.

Kein Banner zum Anzeigen