Blank Cell

[Guest]

Hello Exceller’,
I am trying to convert a cell to a blank based on an IF argument. I have a
graph reading off this cell and I want it to be read as a blank cell. I am
using the following formula =IF(C18>0.1,C18,â€â€), however while the cell
appears blank the graph is still reading this cell as “0†and creating the
line graph to zero.
Thank you for any assistance

 

[Mladen_Dj]

Hello Exceller',
I am trying to convert a cell to a blank based on an IF argument. I have a
graph reading off this cell and I want it to be read as a blank cell. I am
using the following formula =IF(C18>0.1,C18,""), however while the cell
appears blank the graph is still reading this cell as "0" and creating the
line graph to zero.
Thank you for any assistance

Try formula:

=IF(C18>0.1,C18,NA())

Regards

 

[Gord Dibben]

Lester

Try this version. #N/A won't plot.

=IF(C18>0.1,C18,NA())


Gord Dibben MS Excel MVP

 

[Guest]

Gord & Malden,

Many thanks guys, works perfectly.

Your help is much appreciated...
Have a grate day
Lester