### ROUND(number, num_digits)

Returns the number rounded to a specified number of digits.

 number The number you want to round. num_digits The number of digits to which you want to round 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 ROUNDDOWN function if you always want the number rounded down to the nearest integer.* You can use the ROUNDUP function if you always want the number rounded up to the nearest integer.* You can use the FLOOR.MATH function to round down to the nearest integer or significant figure.* You can use the CEILING.MATH function to round up to the nearest integer or significant figure.* You can use the MROUND function to round to a desired multiple.* 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.* For the Microsoft documentation refer to support.office.com

 A 1 =ROUND(123.456,-4) = 0 2 =ROUND(123.456,-3) = 0 3 =ROUND(123.456,-2) = 100 4 =ROUND(123.456,-1) = 120 5 =ROUND(123.456,0) = 123 6 =ROUND(123.456,1) = 124 7 =ROUND(123.456,2) = 123 8 =ROUND(123.456,3) = 123 9 =ROUND(123.456,4) = 123 10 =ROUND(56.78,-4) = 0 11 =ROUND(56.78,-3) = 0 12 =ROUND(56.78,-2) = 100 13 =ROUND(56.78,-1) = 60 14 =ROUND(56.78,0) = 57.00 15 =ROUND(56.78,1) = 56.80 16 =ROUND(56.78,2) = 56.78 17 =ROUND(56.78,3) = 56.78 18 =ROUND(56.78,4) = 56.78