To use this function, choose Calc > Calculator.

Rounds a number up based on the number of decimal places you specify. For example, the number 2.3572 becomes:
  • 2 when rounded to the nearest whole number
  • 2.4 when rounded to one decimal place (or the nearest tenth)
  • 2.36 when rounded to two decimal places (or the nearest hundredth)
  • 2.357 when rounded to three decimal places (or the nearest thousandth)
Tip

Use the Floor function to round down. Use the Ceiling function to round up.

Syntax

ROUND(number,decimals)

For number, specify the number or column of numbers you want to round. For decimals, specify the number of places to round to.
  • If decimals = 0, the number is rounded to the nearest integer.
  • If decimals > 0, the number is rounded to the specified number of decimal places after the decimal point.
  • If decimals < 0, the number is rounded to 1 minus the specified number of place values to the left of the decimal point.

Examples

Calculator expression Result
ROUND (2.136, 0) 2
ROUND (2.136, 1) 2.1
ROUND (2.136, 2) 2.14
ROUND (-2.136, 1) -2.1
ROUND (253.6, -1) 250
ROUND (253.6, -2) 300
Note

If you round a column and store the results within that same column, you cannot get back the full decimal expression.

By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy