How to Calculate BMI in Excel

Techwalla may earn compensation through affiliate links in this story.

If you have basic knowledge of Excel, you can set up a body mass index (BMI) Spreadsheet in no time. Even if you have very little experience with Excel, you should still be able to set up this spreadsheet following these instructions.

Step 1

Set up Title, Columns and Rows

Begin with the title and fill in the columns you will need: Weight, height and BMI. Next, set up the rows accordingly. For this spreadsheet I included both the English and metric versions since both Excel formulas are different.

Step 2

Plug in the BMI English Formula

Next, fill in the Excel formula for calculating the BMIs for each measuring system: English and Metric. The formula for the English BMI is weight multiplied by 703 (which is just a conversion factor) divided by height squared. You would type in this formula as it corresponds to which Excel Cells you are using in your spreadsheet. In this case the formula corresponds with the data being placed in Cells B4 and C4, so the formula in Cell D4 would be =703*B4/C4^2

Step 3

Plug in the BMI Metric Formula

Next, plug in the Excel formula for the metric version in the appropriate column. The formula for this calculation is weight divided by the height squared or on this spreadsheet: =B7/C7^2