PDA

View Full Version : Excel Help!!


NikkiT
11-23-2007, 02:02 PM
For anyone who is good with Excel formulas-- I'm trying to do something quite simple (I think), but I'm a complete n00b and I cannot get it right!

I want one cell to be able to calculate BMR (how many calories per day that you burn if you do nothing at all), based on weight.

So, if A1 was 150, then B1 would be 1486.
If A1 was 145, then B1 would be 1464.

I can make the first part work by using:
=IF(A1=150;1486;0)

But I need to put all of the other BMR values in that cell as well so it changes with the weight, and I'm not sure how to include more than one formula in a cell! Is that possible, or am I approaching it the wrong way?

Thank you soooo much! It's driving me nuts!

callinq
11-23-2007, 04:14 PM
see here: http://www.bmi-calculator.net/bmr-calculator/
it doesnot give me any equasions but hey...

NikkiT
11-23-2007, 05:16 PM
I know you can do it that way, but it's for my sister and she doesn't have internet access, so I was hoping for something she could use offline-- i.e., an Excel sheet. :)

tinkerbell101
11-23-2007, 06:25 PM
Are you going to factor in height and age as well or just weight? I think I can help.

oasis
11-23-2007, 07:12 PM
What is your email. I just did up a calculator in EXEL that I can email to you