ROUNDDOWN
Description
Rounds to the nearest number toward zero (down if positive; up if negative), to the
number of decimal places that you specify.
Syntax
ROUNDDOWN(
number
,
num_digits
)
- number: The number to round.
- num_digits: The number of decimal places to round to. Specify 0 to round down to the closest integer. A positive num_digits specifies the number of digits to the right of the decimal point. A negative num_digits specifies the number of digits to the left of the decimal point.
Example
Formula | Result |
|---|---|
=ROUNDDOWN(12.34,0) | 12 |
=ROUNDDOWN(-12.34,0) | -12 |
=ROUNDDOWN(12.34,-1) | 10 |
=ROUNDDOWN(-12.34,-1) | -10 |