Making a cell with a formula appear empty

[macaonghus]

I have a chart with blank values in some cases. I have set up the chart to show those values as gaps, which relies on the blank cell being empty.

However, my blank cells have a formula along the lines of:

if (condition,value,"")

So the chart does not consider them blank, presumably either because the formula is in there, or because "" is not the same as blank.

How can I make this cell appear blank for the purposes of the chart?

This is related to another thread: http://www.excelforum.com/excel-gene...o-display.html.

[NBVC]

I think DonkeyOte answered that in the other thread...

Did you try replacing the "" in the formula with NA() so that #NA appears instead of Blank... the chart will ignore those #NA

[zbor]

You must put NA() instead of blank.. Then it will work..

[Ron Coderre]

Charts ignore cells with error values.
Try this construct:

Please Login or Register  to view this content.

Does that help?

[macaonghus]

Thank you both...and thank you donkeyote.

[macaonghus]

I am amazed at how much Excel knowledge there is here.