| Applies from Version: | WEBcnx 2024.1 | Applies to Version: |
Description
Rounds a number to a specified number of digits.
Syntax
ROUND(number, num_digits)
The ROUND function 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.
Returns
A rounded number
Remarks
- If num_digits is greater than 0, then number is rounded to the specified number of decimal places.
- If num_digits is 0, then number is rounded to the nearest integer.
- If num_digits is less than 0, then 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.
- To round a number to a specific multiple (for example, to round to the nearest 0.5), use the MROUND function.
Examples
| Expression | 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 |