Forum Discussion
Configuring multiple IF Statements to a cell
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!
Hello James
=LOOKUP(H3,{0;18.5;25;30},{"Underweight";"Normal";"Overweight";"Obese"})
3 Replies
- Detlef_LewinSilver Contributor
Hello James
=LOOKUP(H3,{0;18.5;25;30},{"Underweight";"Normal";"Overweight";"Obese"})- Sosheel_GodfreyCopper Contributor
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
- James RudnikCopper Contributor
Well I was way off.... thanks! It worked perfectly.