REALLY blank result from "" in an IF function?

  • Thread starter Thread starter sabisti
  • Start date Start date
S

sabisti

I'm trying to use an IF funtion to apply a formula over a column of data
and then, plot the results. The problem is that some data is not
available an I have to use a formula like:
=IF(B2>0,A2/B2,"")

Now Excel does not treat the "blank" result as blank. So that If I use
the "=Isblank(C2)" function referring to that cell, the result is
FALSE.

The problem is that when I try to plot the data from the new column,
the "blank" values are plotted as 0's (zeros), no matter what I've set
in "Tools->Options->Chart"

Any suggestions?

Thanks a lot in advance!

Victor.
 
...
...
The problem is that when I try to plot the data from the new column,
the "blank" values are plotted as 0's (zeros), no matter what I've set
in "Tools->Options->Chart"
Click to expand...

Use NA() or #N/A rather than "". In charts, #N/A is treated the same as blanks.
 
Thanks for the answer, but If I use NA(), the plot interpolates between
the two neighbours of the Non available point, and I want to the plot
to leave that region of the plot empty (gap).

Thanks.

Victor.
 
sabisti said:
Thanks for the answer, but If I use NA(), the plot interpolates between
the two neighbours of the Non available point, and I want to the plot
to leave that region of the plot empty (gap).
Click to expand...

For gaps, you need blank cells. No work-arounds. Do you want to use a macro
to delete cells evaluating to text rather than numbers? That's the only
alternative to manually deleting cells evaluating as text.
 
No, thanks. I'll just stop trying to find a way to set a cell as "blank"
with a formula.

Yet another reason to hate MS applications.... sorry.

Thanks a lot!

VIctor.
 
Back
Top