Creating my own BMR (basal metabolic rate) Calculator

[ramghai]

I want to create my own basal metabolic rate (BMR) calculator in Excel 2010 using the Harris Benedict Formula

I want it to be in imperial and metric, male and female

I want the BMR to be calculated in C9
The age is in C3 - I have used data validation in that cell
The gender is in C4 - I have used a drop down list for Male or Female
The weight is in C5 - The user can input data in kg or st,lb, using the drop down menu
The heigh is in C6 - Users can input data in m or ft,in using the drop down menu

In cell C8, I have the
I want the BMR to be calculated in C9

Any help would be much appreciated!

 

[ramghai]

no, what do i ask help for :/

 

[shg]

I don't understand what you're asking. You can enter weights in lbm, ozm, g, or kg, and height in ft, in, m, or cm.

 

[ramghai]

I don't understand what you're asking. You can enter weights in lbm, ozm, g, or kg, and height in ft, in, m, or cm.

Do you want a download link to the speadsheet so you get a better understanding of what i need?

 

[shg]

No, I think I understand it. Does the example not do as you describe, other than not supporting weight in stones?

 

[p45cal]

C9 is the important bit for you:

Excel Workbook
	B	C	D	E	F
3	age	54
4	gender	Male
5	weight	13	st	7	lb
6	height	6	ft	1	in
7
8
9	BMR	1808.325
Sheet

#VALUE!

Using the original equations from Harris and Benedict from http://en.wikipedia.org/wiki/Basal_metabolic_rate

 

[ramghai]

No, I think I understand it. Does the example not do as you describe, other than not supporting weight in stones?

the example works ok, just doesn't work with stones and pounds

 

[shg]

Works fine for me with pounds, except the abbreviation is lbm, not lb.

 

[ramghai]

sad to say but its not working for me

just to make it clear, D5 is the drop down menu for "kg" and "st".
When "st" is selected from the drop down list, then a box to input data for "lb" appears.

I have the same process for the height.

 

[p45cal]

sad to say but its not working for me

just to make it clear, D5 is the drop down menu for "kg" and "st".
When "st" is selected from the drop down list, then a box to input data for "lb" appears.

I have the same process for the height.

You seem to have ignored my offering.

 

[ramghai]

You seem to have ignored my offering.

what was it?