Explanation
TheROUND functionrounds a number to a given number of places.
The number of places is set by the number of digits provided in the second argument (num_digits).
The ROUND function can round to the right or left of the decimal point.
Round a number
To round a number up or down to the nearest specified digit, you can use the ROUND function with a specified number of digits. In the example shown, the formula in cell D6, copied down, is: =ROUND(B6,C6)
