• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. Q

    Charting formula results showing 0 when it should be blank

    Okay - I re-read your solution and realized that the formula would show as the #N/A error message and that DID WORK!!!!!! THANK YOU SO MUCH - you're my HERO!!!!!
  2. Q

    Charting formula results showing 0 when it should be blank

    That is N/A as in "not applicable".
  3. Q

    Charting formula results showing 0 when it should be blank

    I'm sorry - I forgot to state that in addition to the score value of 0-5, there can also be an N/A. But I can't use your suggested formula because 0 is actually a score. But maybe I could some other text that would be ignored. I'll try something like: =IF(myformula = "","blank",myformula)...
  4. Q

    Charting formula results showing 0 when it should be blank

    Thank you in advance for your expertise!! I have a worksheet with dynamic charts using the indirect function (which I learned from chandoo.org). The raw data is a score value of 0-5 for each day of the month. But there are some days where there is no score, but because there is the Indirect...
Back
Top