Support » Plugin: Calculated Fields Form » IF Calculation

• Resolved markharkin

(@markharkin-1)

Hi
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?

Thanks
Mark

http://wordpress.org/extend/plugins/calculated-fields-form/

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

(@codepeople)

Hi,

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:

(function(){
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.