SOLVED
Home

Configuring multiple IF Statements to a cell

%3CLINGO-SUB%20id%3D%22lingo-sub-269529%22%20slang%3D%22en-US%22%3EConfiguring%20multiple%20IF%20Statements%20to%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-269529%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20All!%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI'm%20trying%20to%20get%20a%20formula%20configured%20on%20an%20excel%20spreadsheet.%20Basically%2C%20I%20have%20a%20BMI%20and%20I%20want%20it%20to%20automatically%20determine%20whether%20that%20person%20is%20considered%20underweight%2C%20normal%2C%20overweight%2C%20or%20obese.%20I%20tried%20this%20formula%20and%20it%20looks%20like%20a%20jumbled%20mess%20so%20it's%20completely%20wrong%26nbsp%3B%3CBR%20%2F%3E%3DIF(H3%26lt%3B18.5%2C%22Underweight%22%2CIF(H3%3D18.5%3A24.4%2C%22Normal%22%2CIF(h3%3D25%3A29.9%2C%22Overweight%22%2CIF(h3%26gt%3B%3D30%2C%22Obese%22))))%3CBR%20%2F%3E%3CBR%20%2F%3Ebasically%20what%20I%20need%20is%20this%3A%20If%20cell%20h3%20is%20less%20than%2018.5%2C%20it%20will%20enter%20%22Underweight%22%20into%20cell%20I3.%20If%20h3%20is%2018.5-24.9%2C%20it%20will%20enter%20%22Normal%22%20into%20cell%20I3.%20If%20h3%20is%2025.0-29.9%2C%20it%20will%20enter%20%22Overweight%22%20into%20I3.%20and%20finally%2C%20if%20h3%20is%20greater%20than%20or%20equal%20to%2030.0%2C%20I3%20will%20say%20%22Obese%22%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20possible%20to%20do%3F%20I%20feel%20like%20I%20just%20typed%20the%20formula%20horribly%20wrong.%20I'm%20new%20to%20this%20whole%20formula%20thing.%20This%20is%20Excel%202016%20btw.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-269529%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-269573%22%20slang%3D%22en-US%22%3ERe%3A%20Configuring%20multiple%20IF%20Statements%20to%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-269573%22%20slang%3D%22en-US%22%3E%3CP%3EWell%20I%20was%20way%20off....%20thanks!%20It%20worked%20perfectly.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-269572%22%20slang%3D%22en-US%22%3ERe%3A%20Configuring%20multiple%20IF%20Statements%20to%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-269572%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20James%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%3E%3DLOOKUP(H3%2C%7B0%3B18.5%3B25%3B30%7D%2C%7B%22Underweight%22%3B%22Normal%22%3B%22Overweight%22%3B%22Obese%22%7D)%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-869575%22%20slang%3D%22en-US%22%3ERe%3A%20Configuring%20multiple%20IF%20Statements%20to%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-869575%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1639%22%20target%3D%22_blank%22%3E%40Detlef%20Lewin%3C%2FA%3E%26nbsp%3Bthanks%20for%20this%20simple%20solution.%20You%20made%20my%20day.%20I%20spent%20so%20much%20time%20on%20Saturday%20doing%20what%20James%20was%20doing.%20Cheers%2C%20s%3C%2FP%3E%3C%2FLINGO-BODY%3E
James Rudnik
New Contributor

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

Hello James

 

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

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

@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