The real implementation of Excel software rounding

In our day-to-day work, especially in the Excel cell format, we allow the definition of decimal places, but in practice we find that the numbers themselves do not actually achieve rounding. If this rounding method is used, errors often occur in financial operations, which are not permitted by financial operations.

As shown in Figure 1,a1:a5 is the original data, B1:B5 is the result of preserving two decimal places by setting the cell format. C1:C5 is the data that is rounded to the original data of the A1:A5 and then entered. A6, B6 and C6 are the results of "summation" of the above three-column data respectively. Let's look at columns B and C, the same data, and then we'll get a different result. If you look at columns A and b again, it's not hard to see that the results of the two columns are the same, which means that column B is not really rounding, just hiding the decimal digits.

So, is there a simple and workable way to really round it up? In fact, Excel has provided this function, this is the round function, it can return a number by a specified number of digits rounded after the number.

A function is provided in "math and trigonometric Functions" provided by Excel: ROUND (number,num_digits), which is the function of rounding numbers by the number of digits specified (Figure 2). This function has two parameters, number and num_digits, where numbers are the digits that will be rounded, and num_digits is the number of digits after the decimal point that you want to get the number.

Let's take the A1 column data in Figure 1 as an example: Enter "=round (a1,2)" in cell E2 (Figure 3), which is to keep the two-bit decimal number after rounding the data for the A1 cell. When you enter the car, you will get a 0.12 result. Then, select E1 this cell, drag the Fill handle button in the lower right corner to E5, and in the E6 cell e1:e5 sum the result as shown in Figure 3. This is consistent with the results of the C6 cell, which shows that rounding is really true.