what to use if and or vlook up in excel

June 10, 2011 at 19:20:25
Specs: Windows Vista
hi there , i need to get the BMI result of children.ex in in cell E i put their age, in cell M, BMI values in cell O ,Nutritional status that depends on value of cell E and cell M...the Nutritional status could b"SW","W"."N","OW", "O" depending on the value in cell M.if the age is in cell E <=5.3,the conditions in cell O for SW is <=12.9,W<=14.0,N<=18.2,OW<=20.1,O.=20.2. but the conditions in SW,W,N,OW,O varies on the age given in cell E my example applies only for ages <=5.3 but as the age increases the values on the nutritional status range also differ.how can i make a statement using and or vlook up?thanks i hope you can help me on this..

See More: what to use if and or vlook up in excel

Report •

June 10, 2011 at 20:44:15
Your question should be in the Office Software Forum,
but why reinvent the wheel?

Look here:

It's free



Report •
Related Solutions

Ask Question