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?
Please Login or Register to view this content.
Please try:Formula:
Please Login or Register to view this content.
Works perfect! Thanks.
Still wondering why was Excel behaving like that
Last edited by AliGW; 09-30-2022 at 05:02 AM. Reason: Please DON'T quote unnecessarily!
F10 is formatted as Number with 1 decimal place. So, no matter what ROUND(... , 1) returns, it would appear as x.x .Originally Posted by daithy
If you used the format Number with 3 decimal places, you would see x.xxx even though you round to 1 decimal places.
In the expression ROUND(... , 1) &... , we cannot control the format of the value that ROUND returns.
Excel returns the minimum number of digits to represent the result up to 15 significant digits.
Since the result is zero, Excel formats that as "0".
If you format F10 as General, you would also see just 0.
Last edited by curiouscat408; 09-30-2022 at 11:30 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks