Use NA()

as an example instead of


=IF(A1=0,"",A1)

use

=IF(A1=0,NA(),A1)


The formula will show as #N/A but the chart will show as null and if you
don't like the look of the #N/A you can hide it with conditional formatting
using white fonts


--
Regards,

Peo Sjoblom



"Mark Allen" wrote in message
...
The formula works but unfortunatley the blank response is showing as blank
but I am then using dynamic charting and it still shows as 0...I need the
cell to show nothing so it see's the cell as completly blank !!!!!

Help please.

"David Biddulph" wrote:

=IF(SUMIF(F:G,L29,G:G)=0,"",SUMIF(F:G,L29,G:G))
--
David Biddulph

"Mark Allen" wrote in message
...
I am using this formula

=SUMIF(F:G,L29,G:G)

normal answer is for instance 33456
sometime the answer is 0
When the answer is 0 I want the cell to show nothing at all

Is this possible ???

Regards

Mark