Question

Excel: Round up numbers - this is how it works

Answer 1

How to use the ROUND UP function in Excel

---

You can use the ROUND UP function in Excel to round up numbers to a specific decimal place. We'll explain how it's done here..

The ROUND function rounds numbers in Excel down from 1-4 and up from 5-9. But unlike this formula, ROUNDUP always rounds up numbers from 1-9. That might sound more complicated than it actually is.

Also read here for tips on how to work efficiently with Excel.

How to use the ROUND UP function in Excel

To properly use the ROUND UP function, you need two arguments:

• Number : You need a real number, which you want to round up. If you do not know this yet, because it is calculated, for example, you can enter the cell in which the number is calculated instead.
• Number_digits : Here you specify how many decimal places you want to round the number.

What exactly you have to enter for the number of decimal places is shown below:

• If num_digits = 0 , the number is rounded to the nearest whole number. Example: 67.3 is rounded to 68 .
• If num_digits > 0 , the number is rounded to the decimal places you specified to the right of the decimal point. Example: If number_digits = 3 , 5.67327 is rounded to 5.674 .
• If num_digits <0 , the number to the left of the decimal point is rounded to the places you specified, i.e. to the next 10, 100, etc. Example: With num_digits -2 , the number 5873.9 is rounded to 5900 .

So, type = ROUNDUP (number; num_digits) to use the formula..

---