Function Description
| Category | Description |
|---|---|
| Syntax | ROUND(number,num_digits) |
| Function | Returns a number rounded to the specified number of digits. |
| Parameters | number: the number to round num_digits: the number of digits to which the number is rounded |
| Number of Parameters | 2 |
| Parameter Type | Number |
| Return Value Type | Number |
| Notes | If the value of num_digits is greater than 0, the number is rounded to the specified number of decimal places. If the value is equal to 0, the number is rounded to the nearest integer.If the value is less than 0, the number is rounded to the left of the decimal point. |
Examples
| Formula | Result |
|---|---|
ROUND(2.15,1) | 2.2 |
ROUND(2.149,1) | 2.1 |
ROUND(-1.475,2) | -1.48 |
ROUND(21.5,-1) | 20 |