How do I remove 0 from a cell and instead just have the cell blank?
The formula in cell F21 is =(E21/B$5)*100
In E21 there is no data, just blank. But in F21 it shows a 0.
How do I remove 0 from a cell and instead just have the cell blank?
The formula in cell F21 is =(E21/B$5)*100
In E21 there is no data, just blank. But in F21 it shows a 0.
=if(E21,E21/B$5*100,"")
or
=if(E21;E21/B$5*100;"")
Dave
One way...
=IF(COUNT(B5;E21)<2;"";(E21/B$5)*100)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
I could not get any of them to work. Says it something wrong with the formula
That one does not get regonized as a formula in my excel
Which argument separators "," or ";"?
Yea know it suddenly worked The first one in your last post
what if I want to change from 0 to blank in a cell with this formula?: =MIN(E21:E30)
One way...
=IF(MIN(E21:E30);MIN(E21:E30);"")
Thank you so much. My spreadsheets are starting to look good now!
You're welcome. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks