Functions
ROUND
Round to specified decimal places
Try it
When to use it
When should I use ROUND instead of ROUNDUP or ROUNDDOWN?
Use ROUND to round to the nearest value by the usual rules; use ROUNDUP or ROUNDDOWN to always force the result up or down.
What does the second argument of ROUND control?
It sets the number of decimal places; a negative value rounds to tens, hundreds, and so on.
Use cases
Round a price to the nearest cent
Round to the nearest hundred
Used in
Syntax
ROUND(number, digits)Examples
=ROUND(99.44,1) // => 99.4
=ROUND(99.44) // => 99
=ROUND(2.5,0) // => 3