Question

Excel: Rounding - this is how you use the function correctly

Answer 1

ROUND: Basic structure
Special functions

---

In Excel you can use the ROUND function to round numerical values ​​according to mathematical laws. We'll show you how it's done..

The ROUND function in Microsoft Excel can do more than just round up and down a decimal place. Using a few examples, we will show you what you can do with this function. The following instructions work for all versions from Excel 2007 onwards.

It also tells you more about tips about controls and formulas in Excel.

• ROUND: Basic structure
• Special functions

ROUND: Basic structure

The ROUND function is always structured according to the following scheme:

=RUNDEN(Zahl;Anzahl_Stellen)

In the Number field , either enter a cell reference or the number itself. The " number_digits " describes what the number should be rounded to:

• If the number of digits is greater than 0 , for example 2, the number is rounded to the corresponding number of decimal places.
• If the number of digits is less than 0 , the number is rounded to the left of the decimal point. With -1 you indicate that it should be rounded to the next multiple of 10, with -2 to the next multiple of 100 and so on.
• If the number of digits is equal to 0 , it is rounded up or down to the nearest whole number.

example

We have the number 3.1415 in cell A1. If you now enter " = ROUND (A1; 2) " in another cell , the value " 3.14 " will be displayed. With the command you rounded the number in cell A1 to two decimal places..

Special functions

If you want it to always be rounded up or down, you can use modifications of the ROUND function:

• = VRROUNDS (number; multiple)

• With this function you can round to a multiple of a number. The function could look like "= VRUNDEN (17; 10)" and the result would be 20.
• = ROUND UP (number; number_digits)

• This function works exactly like "= ROUND ()", but always rounds up automatically.
• = ROUNDDOWN (number; number_digits)

• This function is the opposite of "ROUND UP ()". It works like "= ROUND ()", only the result is always rounded down directly.

---