9 Replies Latest reply on Nov 15, 2018 9:12 PM by NAYANA MADHEKAR

    Percentages in calculation

    NAYANA MADHEKAR

      My one column result is in %.

      (% to Goal)

      1.PNG

       

      I need a condition saying, =IF([% to Goal]<=20%,20%,IF(20%<[% to Goal]<=40%,0.02,IF(40%<[% to Goal]<=60%,60%,IF(60%<[% to Goal]<=80%,80%,IF(80%<[% to Goal]<100%,100%)))

       

      it doesnt seem to work. Its giving me 0% everywhere. even IF(40%<[% to Goal]<=60%,0.6) doesnt help. I tried number format to percentage with this.

       

      What am i doing wrong?

      Any help is appreciated, ty