Charting with IF Statement

Hello,
I have the following IF statement:

=IF(SUM(F5:G5)=0,"",F5/SUM(F5:G5)*100)

In charting this data, the "" is charted as a 0 instead of a blank. I want
it to be a blank. Is there a way around this?

Thanks,

Bill

The #N/A error is ignored by charts.

=IF(SUM(F5:G5)=0,#N/A,F5/SUM(F5:G5)*100)

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Bill" <[email protected]> wrote in message
news:[email protected]...
> Hello,
> I have the following IF statement:
>
> =IF(SUM(F5:G5)=0,"",F5/SUM(F5:G5)*100)
>
> In charting this data, the "" is charted as a 0 instead of a blank. I
want
> it to be a blank. Is there a way around this?
>
> Thanks,
>
> Bill
>
>

Bill -

=IF(SUM(F5:G5)=0,NA(),F5/SUM(F5:G5)*100)

- Mike
www.mikemiddleton.com

"Bill" <[email protected]> wrote in message
news:[email protected]...
> Hello,
> I have the following IF statement:
> =IF(SUM(F5:G5)=0,"",F5/SUM(F5:G5)*100)
> In charting this data, the "" is charted as a 0 instead of a blank. I
> want it to be a blank. Is there a way around this?
> Thanks,
> Bill