ROUND (Primitive Spread Function) rounds the specified value to the nearest number, using the specified number of decimal places.

SYNTAX:

ROUND(value1,value2)

REMARKS:

Use the value1 argument to specify the number to round. Use the value2 argument to specify the number of decimal places.

Note the following about the value2 argument:

Set value2 to a value greater than zero to round to the specified number of decimal places.
Set value2 to zero to round to the nearest whole number.
Set value2 to a value less than zero to round the value left of the decimal to the nearest ten, hundred, etc. 

EXAMPLES:

ROUND(A3,–2)
ROUND(C4,B2)
ROUND(PI(),5)=3.14159
ROUND(29.2,-2)=0
ROUND(-1.963,0)=-2