The ROUNDDOWN function is a Math and Trigonometry function in Microsoft Excel, and its purpose is to round a number down towards zero. The formula for the ROUNDDOWN function is ROUNDDOWN(number, num-digits). The syntax for the ROUNDDOWN function is below:
- Number: Any real number that you want to round down. It is required.
- Num-digits: The number of digits to which you want to round number. It is required.
How to use the ROUNDDOWN function in Excel
There are 3 methods to use the ROUNDDOWN function in Excel to round up numbers, and we have explained all of them in this post:
- Launch Microsoft Excel.
- Create a table or use an existing table from your files.
- Place the formula into the cell you want to see the result.
- Press the Enter Key.
Launch Microsoft Excel.
Create a table or use an existing table from your files.
Place the formula =ROUNDOWN(A2, B2) into the cell you want to see the result.
Press enter to see the result.
The result is 42 because it is rounded down to zero decimal places.
Drag the fill handle down to display the result for the other numbers in the table.
- In cell C3, the result is 765.56; the number rounds down to two decimal places.
- In cell C4, the result is -333.3; the number rounds down to one decimal place.
- In cell C5, the result is 45000; the number rounds down to three decimal places to the left of the decimal point.
There are two other methods to use the ROUNDDOWN function.
Another way is to click the fx button on the top left of the Excel worksheet.
An Insert Function dialog box will appear.
Inside the dialog box in the section, Select a Category, select Math and Trigonometry from the list box.
In the section Select a Function, choose the ROUNDDOWN function from the list.
Then click OK.
A Function Arguments dialog box will open.
In the Number entry box, input into the entry box cell A2.
In the Num-digits entry box, input into the entry box cell B2.
Then click OK.
Yet another way is to click the Formulas tab, then click the Math and Trigonometry button in the Function Library group.
Then select ROUNDDOWN from the drop-down menu.
A Function Arguments dialog box will open.
We hope this tutorial helps you understand how to use the ROUNDDOWN function in Microsoft Excel; if you have questions about the tutorial, let us know in the comments.
How do you show 2 decimal places in Excel without rounding?
Follow the steps to round a number to two decimal places without using a rounding excel function
- Click the cell with the decimal you want to round down to two decimal places.
- Click the arrow at the right corner of the Number group
- A Format cells dialog box will open.
- Click Number on the left pane.
- In the Decimal places box, put the number to two.
- Then click OK.
How do you round to the nearest 10000 in Excel?
If you want to round a number to the nearest 1000 in Excel, there are various formulas you could use, such as Round, RoundUp, RoundDown, Ceiling. Floor and MRound. These functions are Math and Trigonometry functions, that round numbers.
