Configuring multiple IF Statements to a cell

[James Rudnik]

Hey All!

I'm trying to get a formula configured on an excel spreadsheet. Basically, I have a BMI and I want it to automatically determine whether that person is considered underweight, normal, overweight, or obese. I tried this formula and it looks like a jumbled mess so it's completely wrong 
=IF(H3<18.5,"Underweight",IF(H3=18.5:24.4,"Normal",IF(h3=25:29.9,"Overweight",IF(h3>=30,"Obese"))))

basically what I need is this: If cell h3 is less than 18.5, it will enter "Underweight" into cell I3. If h3 is 18.5-24.9, it will enter "Normal" into cell I3. If h3 is 25.0-29.9, it will enter "Overweight" into I3. and finally, if h3 is greater than or equal to 30.0, I3 will say "Obese" 

Is this possible to do? I feel like I just typed the formula horribly wrong. I'm new to this whole formula thing. This is Excel 2016 btw. 

Thanks!

[#2 · Accepted solution]

Hello James

=LOOKUP(H3,{0;18.5;25;30},{"Underweight";"Normal";"Overweight";"Obese"})

[#3]

Well I was way off.... thanks! It worked perfectly. 

[#4]

@Detlef Lewin thanks for this simple solution. You made my day. I spent so much time on Saturday doing what James was doing. Cheers, s