In the front, we introduced the use of the INT function to construct the rounding function, but sometimes we will encounter more decimal rounding, with the INT function construction will be somewhat laborious, Excel round function can help us. The role of the round function is to return a number that has been rounded off by a specified number of digits. The syntax is "ROUND (number,num_digits)", where number is a figure that needs to be rounded; Num_digits to the specified number of digits, rounded by this digit, or rounded to the specified decimal bit if the num_digits is greater than 0, or rounded to the nearest integer if the num_digits is equal to 0, if the num_digits is less than 0, rounding is rounded to the left of the decimal point.
For example,
=round (2.15, 1) rounds 2.15 to a decimal place, with a result of 2.2
=round (2.149, 1) rounds 2.149 to a decimal place result of 2.1
=round (-1.475, 2) rounding-1.475 to two decimal places results of-1.48)
=round (21.5,-1) rounding 21.5 to the left of the decimal point a result is 20