BMI Classification Using IF Formulae

**supertmanable** · 09-22-2016, 10:34 AM

Hello, everyone.

I'm having a bit of trouble with using the logic in Excel; I've never really used the program before in the past.

I have a set of values in the I column for patient BMIs and I want to give a sort of classification to them so I can represent my data on a pivot table. For the example I have (I2), the patient's BMI is within the healthy range but, since it's over the value 18.5, it just comes up as obese. I can see how the formula would imply that I wanted that value but I have no idea as to how to fix it.

My formula is as follows,

=IF(I2<18.5,"Underweight",IF(18.5<=I2<25,"Healthy",IF(25<=I2<30,"Overweight","Obese")))

Thanks for your help!

**6StringJazzer** · 09-22-2016, 10:39 AM

18.5<=I2<25

is math notation but not valid syntax in Excel. Try this:

=IF(I2<18.5,"Underweight",IF(AND(18.5<=I2, I2<25),"Healthy",IF(AND(25<=I2, I2<30),"Overweight","Obese")))

**JohnTopley** · 09-22-2016, 10:40 AM

Try

=IF(I2<18.5,"Underweight",IF(I2<25,"Healthy",IF(i2<30,"Overweight","Obese")))

**NBVC** · 09-22-2016, 10:41 AM

Need to use AND functions...

=IF(I2<18.5,"Underweight",IF(AND(18.5<=I2,I2<25),"Healthy",IF(AND(25<=I2,I2<30),"Overweight","Obese")))

**supertmanable** · 09-22-2016, 10:43 AM

Thanks for the quick response! Unfortunately, both of those gave me a false.

**supertmanable** · 09-22-2016, 10:45 AM

Oh, nevermind! I just tried again and it worked. Thank you all very much for your help. Odd that it didn't work the first time, though. Sorry for the trouble.