• 412K Members
• 7,680 Online
• 468K Conversations
SOLVED

New Contributor

# 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!

3 Replies
Solution

# Re: Configuring multiple IF Statements to a cell

Hello James

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

# Re: Configuring multiple IF Statements to a cell

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

# Re: Configuring multiple IF Statements to a cell

@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

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies