Nested if statement

[VbaHell]

Being very thick and can't work this out, I need an if statement for the following


0 18.5 Underweight
18.5 25 Normal
24.9 29.9 Overweight
29.9 50 Obesity

=if(A1>0<18.5, "UNDERWEIGHT",IF(A1>18.5<25,"NORMAL",IF(A1>24.9<29.9,"OVERWEIGHT",IF(A1>29.9<50,"OBESITY"))))

Can anyone please help on this

 

[VoG]

Try

=LOOKUP(A1,{0,18.5,24.9,29.9},{"Underweight","Normal","Overweight","Obesity"})

 

[VbaHell]

Thank you so much,