2 Replies Latest reply on Apr 29, 2016 12:07 PM by andrewh37727702

    Convert Excel formula to Javascript

    andrewh37727702 Level 1

      Hello,

       

      Looking to convert these 2 formulas to work in Javascript.

       

       

       

      =IF(D11=0,,IF(D11<=50,16.25,IF(AND(D11>=51,D11<=100),31.5,IF(AND(D11>=101,D11<=150),42.75, IF(AND(D11>=151,D11<=200),52.25,IF(AND(D11>=201,D11<=250),60.5,IF(AND(D11>=251,D11<=300),6 8.25,0)))))))

       

       

       

      =IF(AND(D11>=301,D11<=350),75.25,IF(AND(D11>=351,D11<=400),82,IF(AND(D11>=401,D11<=450),82 ,IF(AND(D11>=451,D11<=500),94.75,IF(AND(D11>=501,D11<=1600),(D11*0.2),IF(D11>=1600,320,0)) ))))