- Applies to: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Starter 2010.
This post gives you a better understanding of how to use the ROUNDDOWN function in Microsoft Excel. It looks at what it means, its formula syntax, key conditions of its use and also an example for you to test to see how it works with some sample data.
The ROUNDDOWN function simply rounds a number down, heading towards zero.
Formula Syntax of ROUNDDOWN Function
The ROUNDDOWN function syntax contains these listed arguments:
- Number – Required. Any actual number that you prefer to be rounded down.
- Num_digits – Required. The number of digits for which you seek to round number.
Key Conditions of using ROUNDDOWN Function
- ROUNDDOWN mimics ROUND, although it constantly rounds a number down.
- When num_digits exceeds 0 (zero), then number is rounded down to the verified number of decimal places.
- Should num_digits be 0, then number is rounded down to the closest integer.
- If num_digits is under 0, then number is rounded down to the left of the decimal point.
Copy the sample data in the below table, and paste it into cell A1 of a brand new Excel worksheet. For formulas to display results, pick them, press F2, and then press Enter. If you must at any time, you can change the column widths to gain a fuller picture of the entire dataset in all its beauty!
|=ROUNDDOWN(3.2, 0)||Rounds 3.2 down to zero decimal places.||3|
|=ROUNDDOWN(76.9,0)||Rounds 76.9 down to zero decimal places.||76|
|=ROUNDDOWN(3.14159, 3)||Rounds 3.14159 down to three decimal places.||3.141|
|=ROUNDDOWN(-3.14159, 1)||Rounds -3.14159 down to one decimal place.||-3.1|
|=ROUNDDOWN(31415.92654, -2)||Rounds 31415.92654 down to 2 decimal places to the left of the decimal point.||31,400|