To use this function, choose .
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.
