Support » Plugin: Calculated Fields Form » IF Calculation

  • Resolved markharkin


    Firstly thanks for such an amazing plugin! and i am wondering if you could help me.

    I want to calculate a formula in relation to what a user inputs for example.

    If fieldname2 is < 1000 I would like to calculate prec((fieldname5-fieldname4)*(fieldname2*0.08/365),2)+fieldname2+40

    If fieldname2 is => 1000 but <10000 I would like to calculate prec((fieldname5-fieldname4)*(fieldname2*0.08/365),2)+fieldname2+70

    If fieldname2 is =10000 1000 I would like to calculate prec((fieldname5-fieldname4)*(fieldname2*0.08/365),2)+fieldname2+100

    Is this possible?


Viewing 1 replies (of 1 total)
  • Plugin Author codepeople



    Yes, that’s possible, the calculated field is very powerful and let you use a snippet of Javascript code if you require of a complex equation:

    Please, use the code below as equation associated to your calculated field:

    if(fieldname2 < 1000){
    return prec((fieldname5-fieldname4)*(fieldname2*0.08/365),2)+fieldname2+40;
    }else if(fieldname2 >= 1000 && fieldname2 < 10000 ){
    return prec((fieldname5-fieldname4)*(fieldname2*0.08/365),2)+fieldname2+70;
    }else if(fieldname2 == 10000){
    return prec((fieldname5-fieldname4)*(fieldname2*0.08/365),2)+fieldname2+100;

Viewing 1 replies (of 1 total)
  • The topic ‘IF Calculation’ is closed to new replies.