ROUND

ROUND —

ROUND(number[,digits])

ROUND function rounds a given number.

number is the number you want rounded and digits is the number of digits to which you want to round that number.

If digits is greater than zero, number is rounded to the given number of digits.
If digits is zero or omitted, number is rounded to the nearest integer.
If digits is less than zero, number is rounded to the left of the decimal point.
This function is Excel compatible.

ROUND(5.5) equals 6.

ROUND(-3.3) equals -3.

ROUND(1501.15,1) equals 1501.2.

ROUND(1501.15,-2) equals 1500.0.

Synopsis