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 you want to round the number to.

REMARKS

* Any digits less than 5 are rounded down.
* Any digits greater than or equal to 5 are rounded up.
* The "number" can be a number, a cell reference or a named range.
* If "num_digits" > 0, then "number" is rounded to the specified number of decimal places.
* If "num_digits" = 0, then "number" is rounded to the nearest integer.
* If "num_digits" < 0, then "number" is rounded to the left of the decimal point.
* This function operates on the actual value in the cell and rounds them so they are consistent with the value that is displayed.
* Using this function will change the underlying value and not just the value that is displayed.
* You can use the CEILING.MATH function to round up to the nearest integer or significant figure.
* You can use the EVEN function to round up to the nearest even integer.
* You can use the FLOOR.MATH function to round down to the nearest integer or significant figure.
* You can use the INT function to return a number rounded down to the nearest integer.
* You can use the MROUND function to round to a desired multiple.
* You can use the ODD function to round up to the nearest odd integer.
* You can use the ROUNDDOWN function to round down to a certain number of decimal places or digits.
* You can use the ROUNDUP function to round up 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(123.456, 4) = 123.4560
2	=ROUND(123.456, 3) = 123.456
3	=ROUND(123.456, 2) = 123.46
4	=ROUND(123.456, 1) = 123.50
5	=ROUND(123.456, 0) = 123
6	=ROUND(123.567, 0) = 124
7	=ROUND(123.456, -1) = 120
8	=ROUND(123.456, -2) = 100
9	=ROUND(123.456, -3) = 0
10	=ROUND(123.456, -4) = 0
11	=ROUND(0.024, 2) = 0.020
12	=ROUND(-0.026, 2) = -0.030

1 - What is the number 123.456 rounded to 4 decimal places.
2 - What is the number 123.456 rounded to 3 decimal places.
3 - What is the number 123.456 rounded to 2 decimal places.
4 - What is the number 123.456 rounded to 1 decimal place.
5 - What is the number 123.456 rounded to 0 decimal places. This is rounded down.
6 - What is the number 123.567 rounded to 0 decimal places. This is rounded up.
7 - What is the number 123.456 rounded to -1 decimal places.
8 - What is the number 123.456 rounded to -2 decimal places.
9 - What is the number 123.456 rounded to -3 decimal places. There are only 3 digits on the left of the decimal place.
10 - What is the number 123.456 rounded to -4 decimal places. There are only 3 digits on the left of the decimal place.
11 - What is the number 0.024 rounded to 2 decimal places. This is rounded down.
12 - What is the number -0.026 rounded to 2 decimal places. This is rounded down.