This function rounds the specified value to the nearest number, using the specified number of decimal places.
ROUND(value,places)
Use the value argument to specify the number to round. Use the places argument to specify the number of decimal places. The places argument has these rules:
The result may be rounded up or rounded down.
Accepts numeric data for both arguments. Returns numeric data.
ROUND(A3,–2)
ROUND(C4,B2)
ROUND(R1C2,2)
ROUND(PI(),5) gives the result 3.14159
ROUND(29.2,-2) gives the result 0 because 29.2 is closer to 0 than to 100.
ROUND(-1.963,0) gives the result -2