Charting with IF Statement

[Bill]

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

 

[RagDyer]

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!
==============================================

 

[Mike Middleton]

Bill -

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

- Mike
www.mikemiddleton.com