Argument | Required/ Optional | Description |
|---|---|---|
numeric_value | Required | Numeric datatype. You can enter any valid expression. Use operators to perform arithmetic before you round the values. |
precision | Optional | Positive or negative integer. If you enter a positive precision, the function rounds to this number of decimal places. For example, ROUND(12.99, 1) returns 13.0 and ROUND(15.44, 1) returns 15.4. If you enter a negative precision, the function rounds this number of digits to the left of the decimal point, returning an integer. For example, ROUND(12.99, -1) returns 10 and ROUND(15.99, -1) returns 20. If you enter decimal precision, the function rounds to the nearest integer before evaluating the expression. For example, ROUND(12.99, 0.8) returns 13.0 because the function rounds 0.8 to 1 and then evaluates the expression. If you omit the precision argument, the function rounds to the nearest integer, truncating the decimal portion of the number. For example, ROUND(12.99) returns 13. |
PRICE | RETURN VALUE |
|---|---|
12.9936 | 12.994 |
15.9949 | 15.995 |
-18.8678 | -18.868 |
56.9561 | 56.956 |
NULL | NULL |
PRICE | RETURN VALUE |
|---|---|
13242.99 | 13200.0 |
1435.99 | 1400.0 |
-108.95 | -100.0 |
NULL | NULL |
PRICE | RETURN VALUE |
|---|---|
12.99 | 13.0 |
56.34 | 56.3 |
NULL | NULL |
PRICE | RETURN VALUE |
|---|---|
12.99 | 13.0 |
-15.99 | -16.0 |
-18.99 | -19.0 |
56.95 | 57.0 |
NULL | NULL |