ROUND

ROUND(number, num_digits)

Returns the number rounded to a certain number of decimal places or digits.

number	The number you want to round.
num_digits	The number of decimal places or digits: (= 0) no decimal places (> 0) the number of decimal places (< 0) the number of digits to the left of the decimal point

REMARKS

* For an illustrated example refer to the Rounding Functions page.
* Positive decimal numbers are rounded up (when last digit >=5) and rounded down (when last digit < 5).
* Negative decimal numbers are rounded up (when last digit >=5) and rounded down (when last digit < 5).
* If "number" is not numeric, then #VALUE! is returned.
* If "num_digits" is not numeric, then #VALUE! is returned.
* You can use the ROUNDUP function to round away from zero to a certain number of decimal places or digits.
* You can use the ROUNDDOWN function to round towards zero to a certain number of decimal places or digits.
* You can use the MROUND function to round to a certain multiple.
* You can use the CEILING.MATH function to round up by default to a certain multiple.
* You can use the FLOOR.MATH function to round down by default to a certain multiple.
* You can use the INT function to round down to the nearest integer.
* You can use the EVEN function to round up to the nearest even integer.
* You can use the ODD function to round up to the nearest odd integer.
* The equivalent VBA function is VBA.ROUND
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=ROUND(0.9, 0) = 1
2	=ROUND(1.1, 0) = 1
3	=ROUND(1.5, 0) = 2
4	=ROUND(-1.5, 0) = -2
5	=ROUND(1234, 3) = 1234
6	=ROUND(1234, -1) = 1230
7	=ROUND(1234, -3) = 1000
8	=ROUND(1234.567, 1) = 1234.6
9	=ROUND(1234.567, -1) = 1230
10	=ROUND(1234, -9) = 0
11	=ROUND("", 0) = #VALUE!
12	=ROUND(1.1, "") = #VALUE!

1 - What is the number 0.9 rounded up to 0 decimal places.
2 - What is the number 1.1 rounded down to 0 decimal places.
3 - What is the number 1.5 rounded up to 0 decimal places.
4 - What is the number -1.5 rounded down to 0 decimal places.
5 - What is the number 1234 rounded to 3 decimal places.
6 - What is the number 1234 rounded down to -1 digits.
7 - What is the number 1234 rounded down to -3 digits.
8 - What is the number 1234.567 rounded up to 1 decimal place.
9 - What is the number 1234.567 rounded down to -1 digits.
10 - What is the number 1234 rounded to -9 digits. There are only 4 digits on the left of the decimal place.
11 - When number is not numeric.
12 - When num_digits is not numeric.