If, however, your intention is to work
from Excel , it is not possible for a
formula to '"empty" a cell; at most,
a formula can make the cell seem empty.
Thanks for your response. To be a little more clear, what I am trying to do
is assign a group of cells a value if a certain condition is true, and leave
them empty if false. What I have done in the past is used "" in my "if"
statement for the false condition. The problem is that while the cell
appears to be empty, Excel treats it as though it contains text.
Thanks for your response. Yeah, the probem is with the CountA. Also, when I
chart the data, Excel treats "" as 0, so it actually puts points on the chart
as Y=0 rather than just excluding them. It does this even when I select
"Plot empty cells" - "not plotted," indicating again that it is not treating
these as empty cells. Oddly, as you noted, the ISEMPTY function does treat
them as empty.
You can try using na() instead of "" in your if statement.
i.e.:
if(condition,na(), false)
instead of
if(condition, "", false)
This won't make the cell appear empty, BUT it will allow you to make a plot
without these values showing up!
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.