How to Make a BMI Spreadsheet on Excel

Written by mark kennan
  • Share
  • Tweet
  • Share
  • Email

BMI stands for body mass index, which is a standard method for determining obesity based on weight and height. BMI is used as a screening tool because height and weight have been found to correlate with body fat. To calculate BMI, you need to know your height in inches and feet and your weight in pounds. By crediting an Excel spreadsheet to calculate BMI for you, you can alter values to see how it would affect your BMI. For example, you could see what effect losing 6.8 Kilogram would have on your BMI.

Skill level:
Moderately Easy

Other People Are Reading

Instructions

  1. 1

    Enter "Weight in Pounds" in cell A1, "Height in Feet" in cell A2, "Height in Inches" in cell A3, "Total Height" in cell A4 and "BMI" in cell A5.

  2. 2

    Enter "=B2*12+A3" in cell B4 to have Excel calculate the total height.

  3. 3

    Enter "=B1/B4^2*703" in cell B5 to calculate the BMI.

  4. 4

    Enter the weight and heights of different people in cells B1 through B3 and the BMI will appear in cell B5.

Tips and warnings

  • The formula for calculating body mass index usually overestimates the percentage of body fat in people with muscular builds while it underestimates the body fat in people lacking muscle mass.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.