Rounds a number to a specified number of digits.
Syntax
ROUND(number,num_digits)
Number is the number you want to round.
Num_digits specifies the number of digits to which you want to round number.
Examples
ROUND(2.15, 1)
equals 2.2
ROUND(2.149, 1)
equals 2.1
ROUND(-1.475, 2)
equals -1.48
ROUND(21.5, -1)
equals 20