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)
Argument |
Description |
Permitted values |
|---|---|---|
value |
Number for rounding |
Numerical value or reference to a cell containing a number |
places |
Number 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.