ROUNDDOWN
Math & Trig
Rounds a number down, toward zero, to a specified number of digits.
Translations
EnglishROUNDDOWN
FrenchARRONDI.INF
SpanishREDONDEAR.MENOS
GermanABRUNDEN
ItalianARROTONDA.DIFETTO
PortugueseARREDONDAR.PARA.BAIXO
DutchAFRONDEN.ONDER
PolishZAOKR.W.DÓŁ
RussianОКРУГЛВНИЗ
TurkishAŞAĞI_YUVARLA
CzechROUNDDOWN
HungarianKEREKÍTÉS.LE
SwedishAVRUNDA.NEDÅT
DanishAFRUND.NED
FinnishPYÖR.KERR.ALAS
Syntax
ROUNDDOWN(number, num_digits)Arguments
numberThe number to round downnum_digitsNumber of decimal places
Examples
=ROUNDDOWN(3.999,2)3.99
Rounds down to 2 decimals
=ROUNDDOWN(29,-1)20
Rounds down to nearest 10
=ROUNDDOWN(-3.9,0)-3
Rounds toward zero
Tips & Best Practices
- •Always rounds toward zero
- •Useful for truncating decimals
- •Negative num_digits rounds left of decimal
Common Mistakes
- •Expecting ROUNDDOWN to behave like normal rounding near .9 - it always truncates toward zero regardless of how close the next digit is
- •Applying ROUNDDOWN to negative numbers and expecting a more negative result - it actually rounds toward zero, making the result less negative
- •Using ROUNDDOWN when the goal was simply to truncate a decimal - TRUNC does the same thing more simply for that case
Related Functions
Frequently Asked Questions
Is ROUNDDOWN the same as TRUNC?
They behave the same for positive numbers, but TRUNC has a simpler default of 0 decimals and no rounding logic to consider - for most everyday use they're interchangeable.
Does ROUNDDOWN make negative numbers more negative?
No, the opposite - it rounds toward zero, so -2.9 becomes -2, not -3.
How do I round down to the nearest 5 or 10?
Use FLOOR instead: FLOOR(A1,5) rounds down to the nearest multiple of 5.
Need to translate a formula using ROUNDDOWN?
Use our translator to convert your complete formula