How to Calculate BMI in Excel: Formula, Steps & Template

Tracking your health often starts with one simple number: your BMI, or Body Mass Index. Instead of doing the math by hand or hunting for an online calculator, you can build your own BMI calculator in a spreadsheet in just a few minutes. In this guide, you will learn the standard BMI formula, how to write it in Excel for both metric and imperial units, and how to extend it into a reusable calculator that labels every result automatically.

How to Calculate BMI in Excel: Formula, Steps & Template

What Is BMI and the Standard BMI Formula

BMI stands for Body Mass Index. It is a quick, inexpensive screening measure that estimates whether your weight is in a healthy range for your height. Health organizations, gyms, schools, and clinics use it to flag underweight, overweight, or obese categories — but it is a screening tool, not a diagnosis, because it does not distinguish muscle from fat.

The standard metric formula is:

BMI = weight (kg) / height (m)²

For example, a person weighing 62 kg at 1.68 m has a BMI of 62 / 1.68² ≈ 21.97. If you prefer imperial units, the same result comes from BMI = 703 × weight (lbs) / height (in)², where 703 is the conversion factor between the two systems.

Standard BMI formula weight height

Adult BMI results are usually interpreted with these widely used cutoffs: below 18.5 is underweight, 18.5 to 24.9 is normal, 25 to 29.9 is overweight, and 30 or above is obese. Keep in mind that athletes, older adults, and children need different interpretations.

Use Word, Excel, and PPT for FREE

Free Download

How to Calculate BMI in Excel with the Metric Formula

If your weight is in kilograms and your height is in meters, the BMI formula in Excel is a one-liner. Here is how to set it up from scratch:

1. Enter your headers. In cells A1 to D1, type Name, Weight (kg), Height (m), and BMI.

2. Add your data. In row 2, type the person's name, weight in kilograms (for example, 62), and height in meters (for example, 1.68).

3. Write the BMI formula. In cell D2, enter =B2/C2^2 and press Enter. The caret (^) squares the height, so the formula divides weight by height squared.

4. Fill down. Drag the fill handle or double-click it to copy the formula for everyone in your list. If you work with long tables, you can also apply a formula to an entire column without dragging.

5. Round the result. For a cleaner display, wrap it as =ROUND(B2/C2^2,1), which keeps one decimal place.

One common mistake is forgetting parentheses when you convert centimeters inline. If your height is in centimeters, use =B2/((C2/100)^2) instead — dividing by 100 first, then squaring. Without the inner parentheses, the math order goes wrong and the result will be far too small.

Metric BMI formula in spreadsheet

How to Use the BMI Formula with Imperial Units

In the United States, height is usually recorded in feet and inches and weight in pounds. You have two clean options: convert everything to metric with the CONVERT function, or use the 703 factor directly.

Option 1: the 703 factor (fastest)

1. Set up your columns. Put Name, Weight (lbs), Height (in), and BMI in cells A1 to D1.

2. Enter the data. For example, Maria weighs 140 lbs and is 65 inches tall.

3. Write the formula. In D2, enter =ROUND(703*B2/(C2^2),1). The result is 23.3, a normal BMI.

4. Copy down the column for the rest of your list.

Option 2: convert with CONVERT (keeps metric math)

1. Convert weight to kilograms. In an empty column, use =CONVERT(B2,"lbm","kg").

2. Convert height to meters. Use =CONVERT(C2,"in","m"). If height is split across feet and inches, first combine them as =C2+D2/12 total inches, then convert.

3. Apply the metric formula. Divide the kilogram value by the meter value squared, exactly as in the previous section.

The 703 shortcut is quicker for one-off tables, while CONVERT is better when your sheet mixes units or feeds other metric calculations.

Imperial BMI formula in spreadsheet

Use Word, Excel, and PPT for FREE

Free Download

How to Build a BMI Formula Calculator with Categories

A raw BMI number is useful, but a label is easier to read. With a nested IF formula, your spreadsheet can turn every BMI value into Underweight, Normal, Overweight, or Obese automatically.

1. Add a Category column next to your BMI column (column E).

2. Enter the nested IF formula. In E2, type: =IF(D2<18.5,"underweight",if(d2<25,"normal",if(d2<30,"overweight","obese")))<>

3. Copy down so every row gets labeled.

4. Optional: highlight the categories. Select the BMI column, then use Home > Conditional Formatting > Highlight Cells Rules to color normal values green and out-of-range values red.

5. Save it as a template. Once the layout works, save a blank copy so you can reuse the same BMI calculator for new groups — a class roster, a gym program, or a family health tracker. For ready-made layouts, you can start from these free BMI index chart templates and add the formulas above.

This small calculator is one of the most practical spreadsheet builds: no macros, no add-ins, and it works identically in Excel, WPS Spreadsheet, and Google Sheets because it uses only core arithmetic and IF logic.

BMI weight categories scale chart

The Best Free Alternative: WPS Office for BMI Calculators

You do not need a paid Microsoft 365 subscription to build any of the above. WPS Office is a free, lightweight office suite whose Spreadsheet app runs every formula in this guide — BMI, ROUND, IF, and CONVERT — with full compatibility with .xlsx and .xls files.

WPS Spreadsheet adds a few conveniences for a BMI tracker: thousands of free health and fitness templates, built-in conditional formatting for the category colors, and cloud sync so your calculator follows you across devices. The interface mirrors familiar spreadsheet layouts, so the steps in this article translate one-to-one.

WPS Office Spreadsheet health workbook

Use Word, Excel, and PPT for FREE

Free Download

FAQs

What is the BMI formula in Excel for kg and meters?

With weight in B2 and height in meters in C2, use =B2/C2^2. The caret operator squares the height, giving weight divided by height squared.

How do I calculate BMI with pounds and inches?

Use the imperial version =703*weight/(height^2). With weight in B2 and height in inches in C2, enter =ROUND(703*B2/(C2^2),1) to get a result rounded to one decimal.

What if my height is in centimeters?

Convert inside the formula: =B2/((C2/100)^2). The inner parentheses divide centimeters by 100 first, converting them to meters before squaring.

How do I label BMI results as underweight or obese?

Add a category column with =IF(D2<18.5,"underweight",if(d2<25,"normal",if(d2<30,"overweight","obese"))) and="" fill="" it="" down.="" pair="" with="" conditional="" formatting="" for="" color="" coding.="">

Is BMI accurate for everyone?

No. BMI is a screening tool based only on height and weight. It can misclassify muscular athletes and does not apply to children the same way, so treat it as a starting point, not a diagnosis.

Free Office Download

   

• Use Word, Excel, and PPT for FREE, No Ads.

• Edit PDF files with the powerful PDF toolkit.

• Microsoft-like interface. Easy to learn. 100% Compatibility.

• Boost your productivity with WPS's abundant free Word, Excel, PPT, and CV templates.

Free Download

100% secure

Algirdas Jasaitis