Question

Excel: Rounding function

Answer 1

How to use the ROUNDDOWN formula correctly

---

The ROUNDDOWN function rounds numbers in Excel down to specific decimal places. We explain how it works..

You can use the ROUNDDOWN function in Microsoft Excel to round off numbers to a decimal place that you specify. It works in the same way as the ROUND UP function, but in the other direction.

Read more here for tips on how to work efficiently with Excel.

How to use the ROUNDDOWN formula correctly

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

• Number : Of course, you need a number that should be rounded down. Alternatively, you can also enter the cell of the number, if it is still being calculated.
• Num_digits : This is how you enter the number of decimal places to round to.

The following options are available for the number of decimal places:

• Number_digits = 0 : The number is rounded to the nearest whole number. Example: 23.9 is rounded to 23 .
• Number_digits > 0 : The number is rounded to the decimal places you specified to the right of the decimal point. Example: If number_digits = 2 , 63.87442 is rounded to 63.87 .
• Number_digits <0 : The number to the left of the decimal point is rounded to the digits you specified, i.e. to the next 10, 100, etc. Example: With Number_digits -3 , the number 3108.97 is rounded to 3000 .

To use the formula now, enter = ROUNDDOWN (number; number_digits) ..

---