In Excel, the round function can complete the rounding operation for us, I believe that friends usually use the round function to round to two decimal places. For example: to 5127 is performed with two decimal places (Figure 1).
The second parameter in the formula, "2", means rounding to two decimal places, and the result is 513 (Figure 2).
According to the above formula, we can expand the idea of the second parameter in the formula, we know that when the second parameter is "0 2", it means that the decimal place of "0 2" is reserved after the decimal point, thenWhat if the second parameter is negative? What will be the effect? The answer is that when the second parameter is negative, it is to round the integer part before the decimal point, and the parameter "-1" is to round the number of single digits, for example: 5127. Round to the "ten" digit (Figure 3).
The result is 510 (Figure 4), and the number after the decimal point can be rounded off.
If the second parameter is "-2", it is rounded to hundreds of digits based on tens of digits. Do you find it practical to use the round function for rounding integers introduced in this issue? Friends are welcome to leave a message in the comment area, and everyone will communicate and learn together. Excel function formulas