A formula to return value based on the sex, age and BMI of a person

		Microsoft Office Forums > Microsoft Excel > Excel
A formula to return value based on the sex, age and BMI of a person

FAQ

Thread Tools

Display Modes

12-11-2018, 06:16 AM

Marcia

Windows 7 32bit A formula to return value based on the sex, age and BMI of a person

Office 2007

Expert

Join Date: May 2018

Location: Philippines

Posts: 553

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 A14

15, 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

BMI.xlsx (24.0 KB, 13 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula to return a value of 1,2,3 or based on a set criteria	Highlander01	Excel	7	06-02-2017 01:17 PM
Return Max Text or Number Value based on Criteria	kwilson307	Excel	1	04-20-2017 05:07 AM
Index to return value based on 2 conditions	george batshon	Excel	2	01-28-2017 05:11 AM
Help with a formula to return a zero	prihia971	Excel	1	10-06-2016 02:17 AM
Return List Based On Specific Value	Helmszee	Mail Merge	1	04-12-2016 02:30 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:28 AM.