# Charting with IF Statement

1. ## 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

2. ## Re: Charting with IF Statement

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" <bill@bpiconsulting.com> wrote in message
> 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
>
>

3. ## Re: Charting with IF Statement

Bill -

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

- Mike
www.mikemiddleton.com

"Bill" <bill@bpiconsulting.com> wrote in message
> 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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1