Forum Discussion
Problem with Formula
Hey guys, I've a wee problem with a formula as follows: Looking for this result: BMI > 30 or WC > 40 (men), 35 (women) So if column 'BMI’ >30 and / or column ‘Waist Cir’ >40 if column ‘Gender’ is ...
Hi,
Please try this formula instead:
=IF(AND(O3>40, D3="M"), 1,IF(AND(O3>35, D3="F"), 1,IF(N3>30, 1, 0)))
This syntax is called (Nested IF).
I think that this is what you looking for!
Regards
Hi,
Please try this formula instead:
=IF(AND(O3>40, D3="M"), 1,IF(AND(O3>35, D3="F"), 1,IF(N3>30, 1, 0)))
This syntax is called (Nested IF).
I think that this is what you looking for!
Regards
Wonderful, it worked perfectly! Thanks a million, Much appreciated.
