Functions
ROUNDDOWN
Round toward zero
Try it
When to use it
When should I use ROUNDDOWN instead of ROUND?
Use ROUNDDOWN to always round toward zero; use ROUND when you want standard nearest-value rounding.
How is ROUNDDOWN different from truncating?
ROUNDDOWN to zero decimals truncates the fractional part, and you can also round down to any number of decimals or to tens.
Use cases
Round down to whole units shipped
Round a figure down to the nearest hundred
Used in
Syntax
ROUNDDOWN(number, digits)Examples
=ROUNDDOWN(99.44,1) // => 99.4
=ROUNDDOWN(99.44) // => 99
=ROUNDDOWN(1234,-2) // => 1200