BMI calculation to state status

[milkiet]

Hi there and thanks for adding me.
I have added a column in a worksheet to show the status compared to bmi number. I have got the following formula:

=IF(G41<=18.5,"underweight",IF(G41<=24.99,"Normal Weight",IF(G41<=29.99,"Overweight",IF(G41<=39.99,"Obese",IF(G41>=40.01,”Morbidly Obese”)))))

This works fine apart from the last part which displays "#NAME?" instead of "Morbidly Obese"

I can't see where this is going wrong. Any ideas anyone?

Thanks in advance.

 

[Fluff]

Hi & welcome to MrExcel.
You have the wrong type of quotes on the last part they should be " not ”

 

[milkiet]

Hi & welcome to MrExcel.
You have the wrong type of quotes on the last part they should be " not ”

Wow, It was that simple. Thanks very much. works a treat

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Dave Patton]

An alternative approach is to use Lookup.

T202105a.xlsm
	G	H	I	J
32			0	Underweight
33			18.5	Normal weight
34			25	Overweight
35			30	Obese
36			40	Morbidly Obese
37
38
39
40
41	24	Normal Weight	Normal weight	Normal weight
42
4a

Cell Formulas
Range	Formula
H41	H41	=IF(G41<=18.5,"Underweight",IF(G41<=24.99,"Normal Weight",IF(G41<=29.99,"Overweight",IF(G41<=39.99,"Obese","Morbidly Obese"))))
I41	I41	=LOOKUP(G41,I32:J36)
J41	J41	=LOOKUP(G41,{0,"Underweight ";18.5,"Normal weight ";25,"Overweight";30,"Obese";40,"Morbidly Obese"})