The ROUND function calculates the value of x rounded to the nearest y.
For example:
ROUND(2.8234, 1) returns 3 (round to nearest whole number)
ROUND(2.8234, 0.01) returns 2.82 (round to nearest hundredth)
ROUND(2678, 100) returns 2700 (round to nearest hundred)
See also: