+ Reply to Thread
Results 1 to 3 of 3

Charting with IF Statement

  1. #1
    Bill
    Guest

    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. #2
    RagDyer
    Guest

    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
    news:ipbFe.9062$oZ.1106@newsread2.news.atl.earthlink.net...
    > 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. #3
    Mike Middleton
    Guest

    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
    news:ipbFe.9062$oZ.1106@newsread2.news.atl.earthlink.net...
    > 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




+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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