Skip to main content

ROUNDDOWN

The ROUNDDOWN function rounds a value down to a specified number of places before or after the decimal point.

This can be useful when you need to ensure that the result does not exceed a certain value, for example, in calculations related to budgets or inventories.

Syntax​

ROUNDDOWN(value, places)

ArgumentDescriptionPermitted values
valueNumber for roundingNumerical value or reference to a cell containing a number
placesNumber of decimal places to which the number needs to be rounded (down)Integer (can be negative) or a reference to a cell containing a number

Examples of use​

Rounding a number down to the nearest whole number

=ROUNDDOWN(3.8, 0)

Result: 3.

Rounding a number down to one decimal place

=ROUNDDOWN(5.67, 1)

Result: 5.6.

Rounding a number down to the nearest hundred with a negative value

=ROUNDDOWN(12345, -2)

Result: 12,300.

Notes​

  • The ROUNDDOWN function always rounds numbers down.
  • If the value of the places argument is positive, the number is rounded down to that number of decimal places.
  • If the value of the places argument is negative, the number is rounded down to the nearest whole number, tens, hundreds, and so forth.