Results 1 to 3 of 3

Thread: if (2000)

  1. #1
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts

    if (2000)

    Hello, so I don't get a div/0 error in my cell I have the following if statement; =IF(F7=0,"",F7/G21). It works as intended but the cell in question and it's column form part of a data series on a line graph. The line shows as 0 for all cells with no value, how can I avoid this? I.e. for Janaury I have a value which is pointed on the graph, February to December which of coure are not run in 2005 have the series line running at 0. I don't want to line value showing for these months. How can I do this.

    Thanks Darren.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: if (2000)

    Shouldn't that be =IF(G21=0,"",F7/G21)? After all, G21 is the value you are dividing by.

    Does using #N/A instead of "" in the formula produce acceptable results?

  3. #3
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: if (2000)

    Should have been and yes that helps.

    Thanks.

Posting Permissions

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