Overview
Syntax | ROUND(Number,Num_digits) | Returns the number rounded to the specified number of decimal places. |
Parameter 1 | Number | Represents the number to be rounded. |
Parameter 2 | Num_digits | Represents the number of digits to which you want to round the number. (If the value of Num_digits is less than 0, the number is rounded to the left of the decimal point.) If the value of Num_digits equals 0, the number is rounded to the nearest integer. If the value of Num_digits is greater than 0, the number is rounded to the specified number of decimal places. |
Notes
1. The function supports two numerical parameters.
2. Generally, the ROUND function follows the rule of rounding up or down.
If a deviation in accuracy occurs under special circumstances, you can use the old_round function instead of the ROUND function for calculation.
Example
Sample data:Sales Details.xlsx
1. In the sample data, you can round the value of Sales Volume to one decimal place.
Click Formula Column in the analysis subject, set Name of Added Formula Column to Round to One Decimal Place for Sales Volume, enter ROUND(Sales Volume,1) after naming, and click OK, as shown in the following figure.
The self-service dataset displays the data with one decimal place, as shown in the following figure.
2. The following table shows more examples.
Formula | Result | Note |
ROUND(2.15,1) | 2.2 | |
ROUND(2.149,1) | 2.1 | |
ROUND(-1.475,2) | -1.48 | |
ROUND(21.5,-1) | 20 |
