How to make a cell look empty

[Rod]

I have a formula like

=If (Something, 10, "")


unfortunately when plotting a graph the zero length string is interpreted as
zero, I want the graph to act as if there is nothing there and hence not to
plot a point.

Any ideas

many thanks

Rod

 

[Frank Kabel]

Hi Rod
try
=If (Something, 10, NA())

to hide the #NA error messages you may use conditional formating and
assign a white font color to these cells

 

[Rod]

Thanks that does it

Hi Rod
try
=If (Something, 10, NA())

to hide the #NA error messages you may use conditional formating and
assign a white font color to these cells

 

[Phyllis]

Another way to make the cell appear empty, is to custom
format the cell using ;;;. This will make any formulas or
data in the field invisible on the sheet, however, if you
click on that field, you can see the data in the formula
bar.