Using Excel type formulas in calculation fields

  • Profile Image
    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?

  • Profile Image
    Huberson
    Answered on May 18, 2016 at 01: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.