MS Excel: ROUNDDOWN Function (WS)
In Microsoft Excel, the ROUNDDOWN function returns a number rounded down to a specified number of digits. (Always rounds towards 0.)
Syntax
The syntax for the ROUNDDOWN function is:
ROUNDDOWN( number, digits )
number is the number to round down.
digits is the number of digits to round the number down to.
Applies To
- Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000
Type of Function
- Worksheet function (WS)
Worksheet Function Example
Let's take a look at an example to see how you would use the ROUNDDOWN function in a worksheet:
Based on the Excel spreadsheet above, the ROUNDDOWN function would return the following:
| =ROUNDDOWN(A1, 0) | would return 662 |
| =ROUNDDOWN(A1, 1) | would return 662.7 |
| =ROUNDDOWN(A2, -1) | would return 50 |
| =ROUNDDOWN(55.1, -1) | would return 50 |
| =ROUNDDOWN(-23.67, 1) | would return -23.6 |