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.
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.
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
滑鼠選中內容，快速回饋問題
滑鼠選中存在疑惑的內容，即可快速回饋問題，我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy