5 Replies Latest reply on Sep 23, 2014 6:07 AM by try67

    Converting excel formulas to javascripts

    csb102155 Level 1

      Hello, I am not experience in Excel formulas and creating "if" statements in Adobe Acrobat, so I'm hoping someone can help me with this. I have two problems.

       

      1.  Here is an excel formula that I need to convert over to javascripts. Can someone help with this?

       

      =IF(Q13>0,Q13+0,"")

       

      2.  Here is the second one,

       

      =IF(N16*Q16>0,((N16*Q16)+U16),"")

       

      In addition to these two formulas I need help with, the owner of the forms does not want the numbers to round up. Is there a way to get the exact answer and not rounding the numbers up in javascript?

       

      Thanks for your assistance.

      I have Adobe Acrobat X.