# Thread: BMI Formula ? (Excel 2002/2003)

1. ## BMI Formula ? (Excel 2002/2003)

Hi

Can anyone help to generate a formula to calculate BMI
Body mass index, or BMI, is a new term to most people. However, it is the measurement of choice for many physicians and researchers studying obesity.
BMI uses a mathematical formula that takes into account both a person's height and weight. BMI equals a person's weight in kilograms divided by height in meters squared. (BMI=kg/m2).

Please see attached

Thanks in advance

Braddy

2. ## Re: BMI Formula ? (Excel 2002/2003)

You provide the height in inches. Since 1 inch = 2.54 cm = 0.0254 m, the formula becomes
<code>
=C10/(B10*0.0254)^2
</code>
(If you're 210 kilograms, you need to do something about your weight!) <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>

3. ## Re: BMI Formula ? (Excel 2002/2003)

Hi Hans

Yeah hence the chart, the result of your formula give a result of 64.57 is should be something like 29.3.( according to my doctor)
Regards

Braddy

4. ## Re: BMI Formula ? (Excel 2002/2003)

Hi,

I would use this formula:

=C10/(POWER(CONVERT(B10,"in","m"),2))

Thanks,
--cat

5. ## Re: BMI Formula ? (Excel 2002/2003)

You stated that the weight was in kilos, but from your extra information, I conclude that the weight is in pounds, not in kilos. Since 1 lb = 453 g = 0,453 kg, the formula now becomes
<code>
=C10*0.453/(B10*0.0254)^2
</code>
You see how important it is to provide correct information!

6. ## Re: BMI Formula ? (Excel 2002/2003)

Hi Cindy,

That does make the formula more readable, but the CONVERT function is only available if you have installed the Analysis ToolPak add-in. If not, you'll get #NAME.

7. ## Re: BMI Formula ? (Excel 2002/2003)

Hi Hans

My humble apologies, <img src=/S/blush.gif border=0 alt=blush width=15 height=15> it's no excuse I know but I origionaly had 94 Kilos but I had checked it in Pounds because I rarely use the Kilo, and forget to change it back.

Thanks very much.

Braddy

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•