Round function is not working Excel

Round function is not working Excel


The ROUND function rounds a number to a specified number of digits. For example, if cell A1 contains 100.7825, and you want to round that value to two decimal places, you can use the following formula:

=ROUND(A1, 2)

The output should be:


There are cases where you want to make decimal places based on a reference cell to auto adjust your round result as shown below, where Range “M3” contains a value which is referenced in given formula so when you change the “M3” value the round would take place upto “M3” cell value.


If you see its not working as expected and result is coming leading zeros you have to use TRIM function to get the correct result as below:


This will make your life easy.

Leave a Reply

Your email address will not be published. Required fields are marked *