How to make a cell look empty

  • Thread starter Thread starter Rod
  • Start date Start date
R

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
 
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
 
Thanks that does it


Frank Kabel said:
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
Click to expand...
 
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.
 
Back
Top