2 Replies Latest reply on Oct 18, 2013 12:34 PM by Beatriz333

    Re: how can I convert an Excel if statement to JavaScript

    Beatriz333

      Hello,

       

      I don't know Java but am trying to create a form.  The Excel if statement would calculate the field as I need it, but I don't know how to convert it to Java.  Your help is greatly appreciated. 

       

      =IF(AND(A3>=5,A3<=20),A3+C3,IF(AND(A3>=5,A3<=20),A3+C3,IF(A3>20,20+C3,"end")))

       

      Thank you.