In Excel, the ROUND function is used to round a number to a specified number of digits.
If “num_digits” is positive, then the rounding will be done to the right of the decimal point. For example, if you want to round the number in cell B3 to three decimal places, you would use the formula =ROUND(B3,3), which would return the value with three decimal places.
If “num_digits” is negative, then the rounding will be done to the left of the decimal point. For example, if you want to round the number in cell B4 to the nearest hundred, you would use the formula =ROUND(B4, -2), which would return the value 2100.
Note that the ROUND function always rounds up if the next digit to be rounded is 5 or greater. For example, if you want to round the number in cell B5 to two decimal places, the result would be 213.15, not 213.14, because 5 is the next digit after the second decimal place.
Share to social media