Someone PLEASE correct my forumla!!

[creature04797]

This should be pretty self explanatory.


=IF((D3=<18.4, "Underweight", ""),IF(D3=18.5<24.9,"Average",""),IF(D3=25<29.5,"Overweight","")IF(D3=>30, "Obese",""))




Basically I have made some formulas and column "D" is my BMI.
I want column "F" (The column I am entering this formula in) to display the condition i.e. "Underweight", "Average", "Overweight", "Obese".

Equal to and less than 18.4 Underweight
Between 18.5-24.9 Average
Between 25-29.5 Overweight
Equal to and greater than 30+ Obese



Can someone please email me on creature04797@hotmail.com with any ideas?





Thanks SO much! :D

[mewingkitty]

=IF(D3<=18.4, "Underweight",IF(18.4<D3<=24.9,"Average",IF(24.9<D3<=30,"Overweight",IF(D3>30, "Obese",""))))

Play with the <= and < as you must

[daddylonglegs]

Hello creature.

The whole point of a forum like this is for discussion to remain within the forum, for all to see and for anybody to contribute.

You can revise your formula like this

=IF(D3="","",IF(D3<=18.4,"Underweight",IF(D3<24.9,"Average",IF(D3<29.5,"Overweight","Obese"))))

[mewingkitty]

=IF(D3<=18.4, "Underweight",IF(18.4<D3<=24.9,"Average",IF(24.9<D3<=30,"Overweight",IF(D3>30, "Obese",""))))

Play with the <= and < as you must

[DonkeyOte]

You could dispense with the IF and use a LOOKUP also

=IF(D3="","",LOOKUP(D3,{0,18.5,25,30},{"Underweight","Average","Overweight","Obese"}))

You may need to do some work with D3 to handle any rounding issues.