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

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

ROUNDDOWN FUNCTION IN EXCEL 1

  • 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

ROUNDDOWN FUNCTION IN EXCEL 2

previous-small ROUNDDOWN Function in Excel                                                                                                                next_small ROUNDDOWN Function in Excel