6 Replies Latest reply: Aug 3, 2012 9:03 AM by Clemens-A. Scherer RSS

    Problems with an ABC-analysis

    Clemens-A. Scherer

      Hello,

       

      I hope you can help me out. Sorry, if I´m in the wrong area, but it`s my first posting.

       

      I´m trying to make an ABC-analysis. For that I accumulate the amount of articles in column 5. In the next step I want to say with an  if-formula, if this article is an A-, B- or C-Article. If the amount is less than 80% it is an A-article, between 80 and 95% it is an B-article and over 95% it is an C-article.

       

      With this formula it doesn`t work...

      if( Column(5)  < 0.80 , 'A', if( Column(5) > 0.95 , 'C', 'B'))

       

      Have you got an idea

       

      Thanks in advance,

      best regards,

      Clemens