# 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. ### Create a progress bar in Excel using VBA (Visual Basic for Applications) ### Get Count of Cells based on Color Excel Add-in using VBA ### Create your own salary slip in Excel with free Template ### TRUNC Function or TRUNC Formula in Excel with example 