Define empty cell in IF-formula not ""

[serranli]

I find different threads on MR. Excel about empty cells that are not really treated by excel as being empty. As soon as I use "" in a formula, Excel will still recognise this as a populated cell.

Since they seem to be 'older' discussions, I kind of hope that Microsoft has found a solution for Office 2007 which you already know about.

The problem is that I am making a spreadsheet in which a formula returns "" as result of an IF-formula.
The cell looks blank, but when I make a graph based upon such a cell, the graph shows as if there was the number zero in it.
I tried to indicate in the graph-properties to show hidden values as gaps, but it doesn't do the trick.
I can't use macro's /VBA either.. would anyone have a solution? Does some kind of 'clearcontents' formula exist or an alternative for "" that does not influence my graph?

Thank you in advance for any feedback

 

[Stormseed]

Could you please post your IF() formula which returns a "" ?

 

[serranli]

This is the formula:

=IF(TODAY()>=DATE(2009;4;30);((B7*200000)/C7);"")

Rgrds

 

[Yard]

If your data is for a chart then you could consider replacing "" with NA().

This will generate a #N/A error in those cells, and the graph will not plot them. You could always use conditional formatting to "hide" the #N/A errors as they are not very pretty!

 

[serranli]

Thanks a lot, this works just fine!