.png)
ROUND Function
The ROUND function rounds a number to a specified number of digits, keeping reports and calculations consistent and readable.
Syntax
=ROUND(number, num_digits)Examples
=ROUND(123.456, 2) ' 123.46
=ROUND(123.456, 0) ' 123
=ROUND(123.456, -2) ' 100A negative num_digits rounds to the left of the decimal point - useful for rounding to the nearest hundred or thousand.
ROUNDUP and ROUNDDOWN
Unlike ROUND, which rounds to the nearest value, these two always round in one direction.
=ROUNDUP(123.421, 2) ' 123.43
=ROUNDDOWN(123.429, 2) ' 123.42Rounding only changes how a number is displayed in the calculation result - use cell formatting instead if you only want to change how a number looks without altering the value used in other formulas.