BMI Formula ? (Excel 2002/2003)

Topic

New Reply

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

Reply | Quote

Replies

You provide the height in inches. Since 1 inch = 2.54 cm = 0.0254 m, the formula becomes

=C10/(B10*0.0254)^2

(If you’re 210 kilograms, you need to do something about your weight!)

Reply | Quote

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

Reply | Quote

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

=C10*0.453/(B10*0.0254)^2

You see how important it is to provide correct information!

Reply | Quote

Hi Hans

My humble apologies, 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

Reply | Quote

Hi,

I would use this formula:

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

Thanks,
–cat

Reply | Quote

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.

Reply | Quote