Help Centre › Functions & Formulas
For a full list of available calculation functions, please read What calculation functions are supported.
This article describes the formula syntax and usage of the ROUND function.
Description
The ROUND function rounds a number to a specified number of digits. For example, if cell A1 contains 23.7825, and you want to round that value to two decimal places, you can use the following formula:
Syntax
ROUND(number, num_digits)
The ROUND function syntax has the following arguments:
- number - Required. The number that you want to round.
- num_digits - Required. The number of digits to which you want to round the number argument.
Remarks
- If num_digits is greater than 0 (zero), then number is rounded to the specified number of decimal places.
- If num_digits is 0, the number is rounded to the nearest integer.
- If num_digits is less than 0, the number is rounded to the left of the decimal point.
- To always round up (away from zero), use the ROUNDUP function.
- To always round down (toward zero), use the ROUNDDOWN function.
Example
| Formula | Description | Result |
| =ROUND(2.15, 1) | Rounds 2.15 to one decimal place. | 2.2 |
| =ROUND(2.149, 1) | Rounds 2.149 to one decimal place. | 2.1 |
| =ROUND(-1.475, 2) | Rounds -1.475 to two decimal places. | 1.48 |
| =ROUND(21.5, -1) | Rounds 21.5 to one decimal place to the left of the decimal point. | 20 |
| =ROUND(626.3,-3) | Rounds 626.3 to the nearest multiple of 1000. | 1000 |
| =ROUND(1.98,-1) | Rounds 1.98 to the nearest multiple of 10. | 0 |
| =ROUND(-50.55,-2) | Rounds -50.55 to the nearest multiple of 100. | -100 |
Errors
For a full list of formula errors, please read Formula errors.