ROUND

ROUND(number, num_digits)

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

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 illustrated examples refer to the Rounding Functions page.
* Numbers are rounded up (when last digit >=5) and rounded down (when last digit < 5).
* This function follows standard rounding rules.
* All numbers are rounded to 15 significant digits before any rounding takes place.
* If "number" is not numeric, then #VALUE! is returned.
* If "num_digits" = 2, the number will be rounded to the nearest 0.01.
* If "num_digits" = 1, the number will be rounded to the nearest 0.1.
* If "num_digits" = 0, the number will be rounded to the nearest integer.
* If "num_digits" = -1, the number will be rounded to the nearest 10.
* If "num_digits" = -2, the number will be rounded to the nearest 100.
* 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.
* You can use the ROUNDDOWN function to round towards zero to a certain number of decimal places.
* 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 the nearest integer or multiple.
* You can use the FLOOR.MATH function to round down (by default) to the nearest integer or multiple.
* You can use the INT function to return a number rounded down to the nearest integer.
* You can use the EVEN function to return the number rounded to the nearest even integer.
* You can use the ODD function to return the number rounded to the nearest odd integer.
* You can use the TRUNC function to round towards zero and truncated to a certain number of decimal places or digits.
* The equivalent VBA function is VBA.ROUND
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=ROUND(12.344, 2) = 12.34
2	=ROUND(12.345, 2) = 12.35
3	=ROUND(12.345, 1) = 12.3
4	=ROUND(12.345, 0) = 12
5	=ROUND(0.9, 0) = 1
6	=ROUND(1.1, 0) = 1
7	=ROUND(1.5, 0) = 2
8	=ROUND(-1.5, 0) = -2
9	=ROUND(1234, 3) = 1234
10	=ROUND(1234, -1) = 1230
11	=ROUND(1234, -3) = 1000
12	=ROUND(1234.567, 1) = 1234.6
13	=ROUND(1234.567, -1) = 1230
14	=ROUND(1234, -9) = 0
15	=ROUND(1.1, "text") = #VALUE!

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