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 1235.698
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
Request a call back and we will phone you back within the next 24hrs
We conduct our business with the highest standards of ethical values and always respect our clients, ensuring that their business requirements are achieved and that their expectations are exceeded. These values are at the core of our company culture and guide our actions and decisions.
QuantiCloud Technologies | Custom Software Solutions. | © 2024. | Privacy Policy