Results 1 to 7 of 7
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    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
    If you are a fool at forty, you will always be a fool

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    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. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    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
    If you are a fool at forty, you will always be a fool

  4. #4
    Star Lounger
    Join Date
    Mar 2006
    Location
    Princeton, New Jersey, USA
    Posts
    81
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: BMI Formula ? (Excel 2002/2003)

    Hi,

    I would use this formula:

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

    Thanks,
    --cat

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    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. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    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. #7
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    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
    If you are a fool at forty, you will always be a fool

Posting Permissions

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