If you’re looking to round numbers down to a specified decimal place, Excel’s ROUNDDOWN function is your go-to tool. This article will explore how to use the function with examples. Without further ado, let’s begin!
ROUNDDOWN Function’s Syntax =ROUNDDOWN(number, num_digits)
Excel’s ROUNDDOWN function requires two arguments: the numerical figure to be rounded (number) and the number of decimal places (num_digits). This efficient, easy-to-use tool then rounds your desired number down towards zero with exactitude at the given decimal point amount.
Here are the steps to use the ROUNDDOWN function in Excel:
- Start by entering ROUNDDOWN( in a cell.
- For the initial argument, input the number figure to be rounded.
- For the second argument, enter the number of decimal places to which the number should be rounded.
- Close the parentheses. Press Enter to get the result.
Example: Let’s assume you have the number -46.0372741 in cell A2, which you want to round down. You can use the ROUNDDOWN function in Excel as follows:
Round down to 1 decimal place =ROUNDDOWN(A2,1)
Round down to 2 decimal places =ROUNDDOWN(A2,2)
Round down to 3 decimal places =ROUNDDOWN(A2,3)
Round down to Nearest Integer =ROUNDDOWN(A2,0)
Round down to Nearest 10 value =ROUNDDOWN(A2,-1)
After entering each formula, press Enter to get the value.
As you see, the ROUNDDOWN function in Excel makes it easy to round numbers down to a specific decimal place. So now you know how to use ROUNDDOWN, try it out today and see how it works for your project. Good luck!