2 Replies Latest reply on May 27, 2016 4:08 PM by designbyfit

    Help converting a basic Excel-style formula into JavaScript

    designbyfit Level 1

      I have a self populating table in an Acrobat document; figured out most of the simple equations but I have one slightly more complicated one that needs JavaScript and I know nada.

       

      The reader inputs two values (a), (b)

       

      and if I were to write the fomula in Excel I would write:

       

      =a-(IF(b<20.5,b,20.5))+41.5

       

      Any thoughts on how to translate this?  Thanks!