4 Replies Latest reply on Jan 19, 2012 1:22 PM by chrisjones1120

    Excel spreadsheet with formula's that needs to be in PDF format, Help with Javascript commands.

    chrisjones1120

      I have a field that has a value of Gross amount of loss.

       

      When a number is entered then the service amount is calculated with the formula below.

       

      =IF(F21<1,MAX(P3:P20),MAX(Q3:Q4))

       

       

      It refers to the chart below..

      so if the Gross amount of loss is less then 500 then the service amount is 148

      if it's less than 2500 the service amount is 1,290

      and so on.

       

       

       

       

      0-500=IF(I21>0,148)=IF(F21=1,90)
      500-2500=IF(I21>500.01,290)=IF(F21=2,125)
      2500-5000=IF(I21>2500.01,420)
      5000-10000=IF(I21>5000.01,585)
      10000-20000

      =IF(I21>10000.01,790)

      20000-50000=IF(I21>20000.01,965)
      50000-100000=IF(I21>50000.01,1640)
      over 100000=IF(I21>100000.01,I21*0.024)

       

       

       

      Can i create a script that basically does the same thing?