Displaying text categories depending upon values within a range

[Barty]

Hi,

I'm a total novice with excel and have been playing around trying to build a tool to help with my PT business.
Basically, I am building a BMI calculator in as part of it and want the cell below where the BMI result comes up as a number, (cell E5) to categorise the number based on my below conditions

<18.5 Underweight
18.5 to 24.9 Normal
25 to 29.9 Overweight
>30 Obese

So far I have explored forums and come up with:

=IF(E5<=18.4,"Underweight",IF(AND((E5>18.5),(E5<24.9)),"Normal",IF(AND((E5>25),(E5<29.9)),"Overweight",IF(E5=<30),"Obese",0)))

This appears to work up until Normal, however not after that.

Could someone please show me where I'm going wrong?!

Thanks

 

[Aladin Akyurek]

Hi,

I'm a total novice with excel and have been playing around trying to build a tool to help with my PT business.
Basically, I am building a BMI calculator in as part of it and want the cell below where the BMI result comes up as a number, (cell E5) to categorise the number based on my below conditions

<18.5 Underweight
18.5 to 24.9 Normal
25 to 29.9 Overweight
>30 Obese

So far I have explored forums and come up with:

=IF(E5<=18.4,"Underweight",IF(AND((E5>18.5),(E5<24.9)),"Normal",IF(AND((E5>25),(E5<29.9)),"Overweight",IF(E5=<30),"Obese",0)))

This appears to work up until Normal, however not after that.

Could someone please show me where I'm going wrong?!

Thanks

Try...

=LOOKUP(E5,{0,18.5,25,29.9},{"Underwight","Normal","Overweight","Obese"})

 

[Barty]

Try...

=LOOKUP(E5,{0,18.5,25,29.9},{"Underwight","Normal","Overweight","Obese"})

You rule!

Thanks so much

 

[Aladin Akyurek]

You rule!

Thanks so much

You are welcome.