Using Excel type formulas in calculation fields

  • ccnewsletters
    Asked on May 18, 2016 at 11:29 AM

    Is it possible to use a formula like this - =IF(G5=0,0,((G5*I5)+155)) in a form?

  • Huberson
    Replied on May 18, 2016 at 1:26 PM

    Since the form is not a spreadsheet, I don't think the form can perform calculation the same as in Excel (Or use Excel formulas). But you can use Calculation field to perform almost any type of computation (Use functions like squaring, rounding..). 

    Please take a look a the calculation guides from this link: http://www.jotform.com/help/chapter-9-Form+Calculations.