ROUND(number,num_digits)

Rounds a number to a specified number of digits.

number is the value to round.

num_digits specifies the number of digits to which you want to round number.

If num_digits is greater than 0 (zero), then number is rounded to the specified number of decimal places.
If num_digits is 0, then number is rounded to the nearest integer.
If num_digits is less than 0, then number is rounded to the left of the decimal point.

ROUND(2.15, 1) = 2.2
ROUND(2.149, 1) = 2.1
ROUND(-1.475, 2) = -1.48
ROUND(21.5, -1) = 20

See also:

MROUND