How to create my own BMR calculator?

**Rigras Leever** · 07-01-2011, 04:03 PM

I'm very, very new to Excel, and I need to create my own BMR (Basal Metabolic Rate) calculator for a project at work. I'm very confused by the formula builder.

Here's the formula:

BMR=
Women: 655 + (4.35 x weight in pounds) + (4.7 x height in inches) - (4.7 x age in years)
Men: 66 + (6.23 x weight in pounds) + (12.7 x height in inches) - (6.8 x age in years)

I don't understand how to set it up to make the proper calculations. Is there a step by step tutorial for this?

Thanks in advance!

P.S. - I'm using Excel 2008 for Mac

**daddylonglegs** · 07-01-2011, 04:08 PM

Hello Rigras Leever

I think that should be fairly straightforward.

Let's assume you have 4 cells with information. A2 shows M or F to denote Male or Female, B2 shows weight in pounds, C2 shows height in inches and D2 shows age in years.

Now you can use this formula in E2 for BMR

=IF(A2="M",(66+6.23*B2+12.7+C2-6.8*D2),(655+4.35*B2+4.7+C2-4.7*D2))