# ROUND

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 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 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.* The equivalent VBA function is VBA.ROUND* For the Microsoft documentation refer to support.microsoft.com* For the Google documentation refer to support.google.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.456, -1) = 120 7 =ROUND(123.456, -2) = 100 8 =ROUND(123.456, -3) = 0 9 =ROUND(123.456, -4) = 0 10 =ROUND(0.024, 2) = 0.020 11 =ROUND(-0.026, 2) = -0.030