Round function is not working Excel

Round function is not working Excel

Round:

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:

100.78

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.

=ROUND((D5-E$5)/(F$5)*F$3,M$3)

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:

=TRIM(ROUND((D5-E$5)/(F$5)*F$3,M$3))

This will make your life easy.

Leave a Reply

Your email address will not be published.