I want to display a minimum and maximum number in a range rounded to 1 decimal. In this example 0.0 - 0.2.
But for some reason it's only showing 0 - 0.2. It works fine if I change the Round function to 2 decimals? Or even left just on its ownWhy doesn't Excel display the minimum value correctly?![]()
=ROUND(MIN(G8:H8),1)
Bookmarks