=ROUND
The =ROUND() function rounds a decimal number to the specified number of decimal places.
Syntax
Section titled “Syntax”=ROUND(NumOfDecimals; AnyNumber)Example
Section titled “Example”=ROUND(0; 3.289839)Returns
3
Example
Section titled “Example”=ROUND(2; 3.289839)Returns
3.29
Example
Section titled “Example”You always get back the number of decimal places you asked for, even when they are zeros.
=ROUND(2; 3834.0000)Returns
3834.00
Note: Formula functions are case sensitive and must be in all caps.