ROUNDDOWN Function in Excel – Round down Values in Excel

ROUNDDOWN Function in Excel Rounds down the number to the specified decimal places.

Syntax of ROUNDDOWN function in Excel

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

Result