In Excel, the ROUND function is used to round a value at a specified position.
Normally, many people who have just started using Excel will use the "Number" and "Keep the number of decimal places" in "Format Cells" to achieve this. The effect of numerical display in the table. However, in financial calculations, the problem of inconsistency between the calculation results of the displayed value and the calculation result of the actual value will be cited.
In the above picture, column C is the cell format for the data in column B, and retains 2 decimal places after the decimal point. If they are summed, the result is 156.688 , and financial or statistical standards require that what you see is true, and the summed result at this time is 156.66, a difference of 0.028.
Therefore, in Excel, the standardized data processing method is not to use the methods of "setting cell format", "number" and "retaining the number of decimal places", but to process the formula calculation results through the ROUND function. , making the value displayed in the cell consistent with the actual value.
In the open Excel worksheet, there are several ways to use the ROUND function:
Method 1: Round to 2 decimal places
Input =ROUND (original Formula or data, 2)
Method 2: Round to integer digits
Input=ROUND(original formula or data, 0)
Method 3: Round to hundreds or tens of thousands
Input=ROUND(original formula or data,-2) Round to hundreds
Input= ROUND (original formula or data, -4) Rounded to the nearest ten thousand
Obviously, by setting the cell format, the most that can be achieved is to retain 0 decimal places, that is, it is displayed as an integer, which is inconvenient to calculate the actual amount according to the settlement rules.
The above is the detailed content of How to enter the round function in Excel. For more information, please follow other related articles on the PHP Chinese website!