ROUND
The ROUND function rounds a number to a specified number of decimal places.
Syntax
=ROUND(number, num_digits)
Parameters
number
: The number you want to roundnum_digits
: The number of digits to round to (positive for decimals, negative for left of decimal)
Examples
=ROUND(123.456, 2) // Returns 123.46
=ROUND(123.456, 0) // Returns 123
=ROUND(123.456, -2) // Returns 100