Functions
ROUNDUP
Round away from zero
Try it
When to use it
When should I use ROUNDUP instead of ROUND?
Use ROUNDUP to always round away from zero; use ROUND when you want standard nearest-value rounding.
Why would I round up instead of to the nearest value?
Rounding up is common for billing, capacity, and materials, where you never want to under-count what is needed.
Use cases
Round up units needed to a whole number
Round a cost up to the nearest ten
Used in
Syntax
ROUNDUP(number, digits)Examples
=ROUNDUP(99.44,1) // => 99.5
=ROUNDUP(99.44) // => 100
=ROUNDUP(1234,-2) // => 1300