REALLY blank result from "" in an IF function?

[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.

 

[Harlan Grove]

...
...

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"

Use NA() or #N/A rather than "". In charts, #N/A is treated the same as blanks.

 

[sabisti]

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.

 

[Harlan Grove]

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).

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.

 

[sabisti]

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.