Hi,

In a chart I have a formula that either returns a number or "" in a cell. I
then have a dynamic range set which plots the values on a graph. The problem
is that the chart will plot the ""s as zeros as it sees something in the cell.

Is there a way I can have a true blank cell result coming from a formula?

If not how I can avoid the dynamic range seeing this as a zero?

Thanks
LiAD