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