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!

 

[shg]

You need more cells than that, do you not? Weight and units for weight, height and units for height.

 

[ramghai]

You need more cells than that, do you not? Weight and units for weight, height and units for height.

The cells I have said are where the user input's their data.

Do these images help?

 

[AlphaFrog]

Here's a BMI Calculator Excel template you may find helpful.
http://exceltemplate.net/health/bmi-calculator/

 

[ramghai]

Here's a BMI Calculator Excel template you may find helpful.
http://exceltemplate.net/health/bmi-calculator/

I know how to calculate the BMI, I want the BMR!!

 

[AlphaFrog]

Sorry. My mistake.

Good luck with that.

 

[shg]

      --B--- --C--- -D-
  3      Age     30    
  4   Gender Male      
  5      Wgt    180 lbm
  6      Hgt     71 in 
  7                    
  8                    
  9      BMR 1888.1

The formula in C9 is

=IF(C4="Male",
66.5 + 13.75 * CONVERT(C5, D5, "kg") + 5.003 * CONVERT(C6, D6, "cm") - 6.775 * C3,
65.5 + 9.563 * CONVERT(C5, D5, "kg") + 1.85 * CONVERT(C6, D6, "cm") - 4.676 * C3)

The units need to be something that the CONVERT function recognizes.

 

[ramghai]

The units need to be something that the CONVERT function recognizes.[/QUOTE]

What does it recognize?

 

[ramghai]

The formula works...but only in metric (kg, m)

 

[shg]

Did you look in Help for the CONVERT function?