Skip to main content

ROUND

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)

ArgumentDescriptionPermitted values
valueNumber for roundingNumerical value or reference to a cell containing a number
placesNumber of decimal places to which the number needs to be roundedAn 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.