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, ove...
excel
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Oct 10, 2018

    Hello James

     

    =LOOKUP(H3,{0;18.5;25;30},{"Underweight";"Normal";"Overweight";"Obese"})
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Oct 10, 2018

Hello James

 

=LOOKUP(H3,{0;18.5;25;30},{"Underweight";"Normal";"Overweight";"Obese"})
  • Sosheel_Godfrey's avatar
    Sosheel_Godfrey
    Copper Contributor
    Sep 22, 2019

    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
    Oct 10, 2018

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

Resources