# WordPress.org

## Calculated Fields Form[resolved] How to use the condition "IF" (3 posts)

1. rey.abc
Member
Posted 3 years ago #

First of all, terrific plugin! I love it, thanks for it, im even considering buying it. Im very new to using it still so im a little confused. Im trying to get the condition IF to work, but i cant do it. I tried looking up at http://wordpress.dwbooster.com/forms/calculated-fields-form but could not find my answer.

I have two different BMR formulas, one for males and one for females, both very different. It'd be possible to incorporate it into just 1 calculator if i could use the IF condition but i dont know how to do it, this is what i thought would work but did not:

IF(fieldname5=men, 66 + (6.23*fieldname3) +(12.7*fieldname2) - (6.8*fieldname4), IF(fieldname5=women, 655 + (4.35*fieldname3) + (4.7*fieldname2) - (4.7*fieldname4)))

Ill write what the fieldname means so you can understand it better:
Fieldname5=sex, fieldname3=weight, fieldname2=height, fieldname4=age
Thanks a lot!

PD:
This are the formulas:
*Men: BMR = 66 + ( 6.23 x weight in pounds ) + ( 12.7 x height in inches ) - ( 6.8 x age in years )

*Women: BMR = 655 + ( 4.35 x weight in pounds ) + ( 4.7 x height in inches ) - ( 4.7 x age in years )

2. rey.abc
Member
Posted 3 years ago #

Just posting again to say that i actually Solved this. Incase someone in the future has the same question as i did, this is what i did:

(fieldname5=='men'?66:655) + ((fieldname5=='men'?6.23:4.35)*fieldname3) + ((fieldname5=='men'?12.7:4.7)*fieldname2) - ((fieldname5=='men'?6.8:4.7)*fieldname4)

3. codepeople
Member
Plugin Author

Posted 3 years ago #

Hi,

Another possible solution would be:

(function(){
if(fieldname5=='men'){
return 66+fieldname3*6.23+fieldname2*12.7-fieldname4*6.8;
}else{
return 655+fieldname3*4.35+fieldname2*4.7-fieldname4*4.7;
}
})()

This topic has been closed to new replies.