Notifications
Clear all
Excel Expert
2
Posts
2
Users
0
Reactions
40
Views
Topic starter
Hi, the following formula displays "%" instead of blank if it falls below 0.44%. Could you advise. Thank you.
[<=0.44]#%;;;
Posted : 30/07/2025 6:49 pm
Not sure I fully comprehend your logic here, but note that 0.44 equals 44%. You probably want to use 0.0044 (=0.44%) in your format. And I would expect a 'rule' like [>=0.0044]. Though I may be mistaken. Does that resolve your issue?
This post was modified 15 hours ago by Riny van Eekelen
Posted : 30/07/2025 9:51 pm
