Bine
New member
- Joined
- Dec 3, 2020
- Messages
- 12
- Reaction score
- 0
- Points
- 1
- Excel Version(s)
- Excel 2016
Dear all,
This is driving me crazy, i just want that my formula says e.g. "Underweight" when the value in O2 is below 18.5, "Normal" if the value is between 18.5 and 24.9:
This is driving me crazy, i just want that my formula says e.g. "Underweight" when the value in O2 is below 18.5, "Normal" if the value is between 18.5 and 24.9:
Underweight = <18.5 |
Normal weight = 18.5–24.9 |
Overweight = 25–29.9 |
Obesity = BMI of 30 or greater Why is this not working : =IF(O2<18.5,"Underweight",IF(18.5<=O2<=24.9,"Normal",IF(25<=O2<=29.9,"Overweight",IF(O2>30,"Obesity")))) Thank you so much for any suggestions!! |