=if(A1=5,D2+D3,NA())
--
David Biddulph

"GoingBonkers" wrote in message
...
I'm using an if statement within a data series that I then chart (excel
2003). The if statement is something like =if(A1=5,D2+D3,""). If the
statement is false, I would expect nothing to display in the cell which is
indead the case. However, when I plot the series in a line graph, it plots
that point as a Zero value. Using a =Isblank(Cell #) gives me a false
which
leads me to believe that the cell is truely not blanked. How do I get the
formula to make the cell empty in the eyes of the chart? The Options in
the
Tools drop down for not plotting blank cells is checked already (Chart
Tab).