ROUNDDOWN
Round a number down, towards zero, to a given number of digits — whatever the next digit is.
Syntax
ROUNDDOWN(number, num_digits)| Argument | Required | Description |
|---|---|---|
number | Required | The number to round. |
num_digits | Required | Decimal places to keep. 0 rounds to a whole number; negative values round to tens, hundreds and so on. |
Examples
Every example below was executed against VisiGrid engine 0.54.0 — not
transcribed from another vendor's documentation. Reproduce any of them with vgrid calc.
| Formula | Result | Notes |
|---|---|---|
=ROUNDDOWN(3.29,1) | 3.20 | Shown to two decimal places; the value is 3.2. |
=ROUNDDOWN(-3.29,1) | -3.20 | Towards zero, so a negative number becomes less negative. |
=ROUNDDOWN(4.35,2) | 4.35 | A value already at two decimals is left alone. |
=ROUNDDOWN(1299,-2) | 1200 |
Never overstating
ROUNDDOWN is for amounts that must not be rounded in your favour: completed
units, whole years of service, a discount that may not exceed its cap. It drops
the extra digits instead of rounding them.
ROUNDDOWN, TRUNC, INT and FLOOR
ROUNDDOWN(x,n) and TRUNC(x,n) are the same
calculation. INT differs for negative numbers — it rounds
towards negative infinity, so INT(-4.7) is -5 where ROUNDDOWN(-4.7,0) is -4.
FLOOR rounds down to a multiple, such as the nearest
0.05 below.
Excel compatibility
Matches Excel. Identical to TRUNC when the digit count is given.