The ROUND function rounds a value to a specified number of places before or after the decimal point.
This can be useful when you need to present data in a more convenient and understandable format, for example, in financial reports or when working with scientific data.
Syntax
ROUND(value, places)
Argument |
Description |
Permitted values |
|---|---|---|
value |
Number for rounding |
Numerical value or reference to a cell containing a number |
places |
Number of decimal places to which the number needs to be rounded |
An integer (can be negative) or a reference to a cell containing a number |
Examples of use
Rounding to two decimal places
=ROUND(3.14159, 2)
Result: 3.14.
Rounding to an integer
=ROUND(5.7, 0)
Result: 6.
Rounding to hundreds
=ROUND(12345, -2)
This formula will return 12,300, rounding the number to the nearest hundred.
Notes
–When rounding to a specific decimal place, the next significant digit is taken into account. If it is greater than or equal to 5, the number is rounded up; if it is less than 5, the number is rounded down. This rule applies to both positive and negative numbers.
–If the value of the places argument is positive, the number is rounded to that number of decimal places.
–If the value of the places argument is negative, the number is rounded to whole values, tens, hundreds, and so forth.