I have an IF statement
=IF('Resource Availability New'!D10<"", 'Resource Availability New'!D10,
0)/'L:\Project Control\Actuals\[Monthly Hours.xls]Sheet1'!N$2

but I don't want it to plot the 0 values but the result returned from the
statement is used further down the sheet in a sum formula to which I need to
see the result instead of NA how can I do that?

Beverly

"David Biddulph" wrote:

What does your IF statement produce? If it gives an empty string "", then
it will be treated as zero. Change the "" to NA(). If you want to hide the
NA() values in the worksheet, you can do that by conditional formatting.
--
David Biddulph

"jhall@ifox" wrote in message
...
I don't want to display zeros in my line chart. The cells are not empty -
they contain a formula. I have used a simple if statement to hide a zero
value - however the chart is still showing the datapoint as zero.