Thread: [Solved] A formula to return value based on the sex, age and BMI of a person
View Single Post
 
Old 12-11-2018, 06:16 AM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2007
Expert
  
Join Date: May 2018
Location: Philippines
Posts: 527
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default A formula to return value based on the sex, age and BMI of a person
Hi, I have tables of Body Mass Index (BMI) for boys and Girls containing matrices of BMI categories (Normal, Overweight...). On a separate table is a list of names with corresponding information of sex, age and BMI. Based on the data provided in cells A1415, please help me with a formula to return the category if a person is severely wasted, wasted, normal, overweight or obese in E14 and E15. Thank you. Sheet attached.
Attached Files
File Type: xlsx BMI.xlsx (24.0 KB, 11 views)
Reply With Quote