+ Reply to Thread
Results 1 to 2 of 2

#N/A

  1. #1
    Arturo
    Guest

    #N/A

    Surprising Zeros in Charts

    My model is built.
    Using #N/A - my chart displays perfectly, zeros suppressed.
    This formula is what feeds the values in my chart series.
    =IF(ISERROR(((AVERAGE(SHEET1!BE2:BM2))*(100/5))),””,((AVERAGE(SHEET1!BE2:BM2))*(100/5)))

    If I alter that error handling
    to:=IF(ISERROR(((AVERAGE(SHEET1!BE2:BM2))*(100/5))),"#N/A",((AVERAGE(SHEET1!BE2:BM2))*(100/5)))
    Zero still displays…
    If I may ask – how would I alter this formula to function they way I hope it
    would?

    Sincerely,
    Arturo

  2. #2
    Arturo
    Guest

    RE: #N/A


    =IF(ISERROR(((AVERAGE(SHEET1!BE2:BM2))*(100/5))),#N/A,((AVERAGE(SHEET1!BE2:BM2))*(100/5)))


    "Arturo" wrote:

    > Surprising Zeros in Charts
    >
    > My model is built.
    > Using #N/A - my chart displays perfectly, zeros suppressed.
    > This formula is what feeds the values in my chart series.
    > =IF(ISERROR(((AVERAGE(SHEET1!BE2:BM2))*(100/5))),””,((AVERAGE(SHEET1!BE2:BM2))*(100/5)))
    >
    > If I alter that error handling
    > to:=IF(ISERROR(((AVERAGE(SHEET1!BE2:BM2))*(100/5))),"#N/A",((AVERAGE(SHEET1!BE2:BM2))*(100/5)))
    > Zero still displays…
    > If I may ask – how would I alter this formula to function they way I hope it
    > would?
    >
    > Sincerely,
    > Arturo


+ 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