ROUNDDOWN Function in Excel Rounds down the number to the specified decimal places.
Syntax of ROUNDDOWN function in Excel
ROUNDDOWN(number,num_digits)
number – The number to be rounded down
num_digits – The number of decimal places to which the number has to be rounded down.
- A positive num_digits value specifies the number of digits to the right of the decimal point.
- A num_digits value of 0 specifies rounding down to the nearest integer.
- A negative num_digits value specifies the number of digits to the left of the decimal point.
Example of ROUNDDOWN Function in Excel
FORMULA
- Row number 2 & 3 Rounds down to 1 and 2 decimal places respectively
- Row number 4 Rounds down to nearest integer
- Row number 5 Rounds down to nearest 10
- Row number 6 Rounds down to nearest 100
So the result will be