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

    Percentages in calculation


      My one column result is in %.

      (% to Goal)



      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