Forum Discussion

James Rudnik's avatar
James Rudnik
Copper Contributor
Oct 10, 2018
Solved

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_Lewin's avatar
    Detlef_Lewin
    Silver Contributor

    Hello James

     

    =LOOKUP(H3,{0;18.5;25;30},{"Underweight";"Normal";"Overweight";"Obese"})
    • Sosheel_Godfrey's avatar
      Sosheel_Godfrey
      Copper 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 Rudnik's avatar
      James Rudnik
      Copper Contributor

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

Resources