BMI Formula in Excel: Calculate It Step by Step

Formulas & functions · Updated November 21, 2026

To calculate BMI in Excel, divide weight in kilograms by height in metres squared; for example, with weight in B2 and height in centimetres in C2, enter =B2/((C2/100)^2). For a 70 kg person who is 175 cm tall, the result is about 22.86; if you use pounds and inches, use the imperial formula explained below.

What BMI measures and how the calculation works

Body mass index (BMI) is a screening measure that relates a person’s weight to their height. It produces a number, not a percentage, and it does not directly measure body fat or show where fat is carried. The calculation is useful for summarising height and weight in a consistent way, but it is only one piece of health information.

The underlying metric calculation is weight in kilograms divided by height in metres multiplied by itself. The imperial version uses a conversion factor because pounds and inches are different units. Using the wrong unit combination is one of the most common reasons a spreadsheet returns an implausible BMI.

  • Metric inputs: weight in kilograms and height in metres, or centimetres converted to metres.
  • Imperial inputs: weight in pounds and height in inches.
  • Do not mix units, such as entering pounds in a formula intended for kilograms.

Metric BMI formula for kilograms and centimetres

A convenient worksheet layout is to put a person’s name in column A, weight in kilograms in B, height in centimetres in C, and BMI in D. With weight in B2 and height in centimetres in C2, enter =B2/((C2/100)^2) in D2. For B2 equal to 70 and C2 equal to 175, the formula returns 22.85714286, which displays as 22.86 when rounded to two decimal places.

The division by 100 changes centimetres into metres: 175 cm becomes 1.75 m. The parentheses matter: Excel first converts the height and then squares the converted value. If you already store height in metres in C2, use =B2/(C2^2) instead. With 70 kg in B2 and 1.75 m in C2, this also returns 22.85714286.

To enter the calculation in Microsoft Excel for Microsoft 365 on Windows:

  1. Type clear headings in row 1, such as Name, Weight (kg), Height (cm), and BMI.
  2. Enter each person’s numeric weight and height in the matching row. Keep units consistent for every row.
  3. Select D2, type the formula, and press Enter.
  4. To calculate more rows, select D2 and drag the small fill handle at its lower-right corner down the column, or copy and paste the cell into the rows below. Excel adjusts the row references automatically.

On Excel for Mac and Excel for the web, the formula itself works the same way. Ribbon placement and keyboard behaviour can vary slightly by platform, but the cell references and arithmetic do not change.

Imperial BMI formula for pounds and inches

If weight is recorded in pounds and height in inches, use the standard imperial conversion factor of 703. With weight in B2 and height in inches in C2, enter =703*B2/(C2^2) in D2. For 150 pounds and 68 inches, the result is 22.80487805, or 22.80 to two decimal places. Make sure height is entered as total inches: 5 feet 8 inches is 68 inches, not 5.8 inches.

If your source data gives feet and inches in separate cells, combine them before calculating BMI, or add a helper column for total inches. For example, if feet are in C2 and extra inches are in D2, you could calculate total inches in E2. With that layout, enter =C2*12+D2 in E2; for 5 feet and 8 inches, it returns 68. Then place the weight in pounds in B2 and use the imperial BMI formula with E2 as the height reference: =703*B2/(E2^2). This avoids treating feet as if they were decimal fractions of a foot.

Round and display the result clearly

Excel stores a calculated value at more precision than it may show on screen. For ordinary display, it is usually better to keep the full result in the cell and change the number format rather than round the underlying calculation. Select the BMI cells, then use Home > Number to choose a number format and set the desired decimal places. Two decimal places make examples easy to compare without implying that BMI is an exact health measurement.

If you specifically need a rounded value in another cell, with the unrounded BMI in D2, enter =ROUND(D2,1) in E2. For the 70 kg and 175 cm example, this returns 22.9. The Windows shortcut Ctrl+1 opens Format Cells; on Mac, Command+1 opens the corresponding formatting dialog. Formatting the display does not change the value used by other formulas, while ROUND does create a rounded result that later formulas can use.

Optional adult BMI categories in a worksheet

You can add a category column for a rough adult screening reference, but make the label’s limitations visible. Suppose BMI is in D2 and the category is in E2. Enter =IF(D2="","",IF(D2<18.5,"Underweight",IF(D2<25,"Healthy weight",IF(D2<30,"Overweight","Obesity")))) in E2. If D2 contains 22.86, the formula returns Healthy weight. The formula leaves E2 blank when D2 is blank, and the thresholds are applied from lowest to highest.

Commonly used adult categories are underweight below 18.5, healthy weight from 18.5 to below 25, overweight from 25 to below 30, and obesity at 30 or higher. These are broad categories, not a diagnosis or a personal treatment recommendation. If you use labels in a report, state that the ranges apply to adults and that a clinician can interpret the result alongside other information. The category formula above uses text labels and a blank check; it assumes D2 contains a valid BMI number.

Common spreadsheet errors and how to prevent them

A result far outside a plausible range often signals a data or unit problem rather than a sophisticated Excel issue. Review the inputs and layout before changing the formula. These checks catch many errors:

  • Height entered in centimetres but treated as metres: 175 entered as metres makes the squared height enormous. Use the centimetre formula or convert the value first.
  • Weight in pounds used in the metric formula: convert pounds to kilograms, or use the imperial formula with height in inches.
  • Feet and inches entered as a decimal: 5 feet 8 inches is 68 inches, not 5.8. Convert the parts into total inches.
  • Blank or zero measurements: a zero height causes a division-by-zero error. Do not interpret a calculated error as a BMI; check for missing data.
  • Text mixed into numeric cells: entries such as “70 kg” may be treated as text. Store the number alone and put the unit in the column heading.
  • Wrong cell references after copying: inspect the first and last rows to confirm the formula points to the matching person’s weight and height.

For a shared workbook, headings that include units, consistent number formats, and a note about which formula is being used make mistakes easier to spot. You can also use Excel’s Data Validation feature to limit entries to positive numbers, although reasonable upper and lower limits depend on the data collection context. Validation can reduce accidental text or negative values, but it cannot confirm that a measurement was taken correctly.

What BMI can and cannot tell you

BMI is a population-level screening tool, not a direct measurement of body composition. It does not distinguish fat from muscle, account for fat distribution, or describe fitness, nutrition, or overall health. A muscular person may have a higher BMI without having the same body-fat profile as another person with the same BMI. Conversely, a BMI in a commonly labelled healthy range does not guarantee that someone has no health concerns.

Adult BMI categories should not be applied to children and teenagers using the adult thresholds. For younger people, interpretation typically uses age- and sex-specific growth references rather than the simple adult category labels. Pregnancy, age, and individual medical circumstances can also affect how useful a general BMI figure is. If the result is being used to make a health decision, discuss it with a qualified healthcare professional instead of relying on an Excel label alone.

Frequently Asked Questions

What is the exact Excel formula for BMI in kilograms and metres?
With weight in kilograms in B2 and height in metres in C2, enter =B2/(C2^2). If height is in centimetres in C2, use =B2/((C2/100)^2) instead.

How do I calculate BMI in Excel with pounds and inches?
With pounds in B2 and total height in inches in C2, use =703*B2/(C2^2). Convert feet and inches into total inches before using the formula.

Should I round BMI in Excel?
You can display two decimal places for readability, while keeping Excel’s full stored value. If another calculation must use a rounded result, use ROUND in a separate cell and understand that later formulas will then use the rounded number.

Why does my BMI formula show #DIV/0!?
The height reference is probably zero or blank, so Excel cannot divide by its square. Check that the correct height cell contains a positive numeric measurement and that the formula refers to the intended row.

Can Excel tell me whether a BMI is healthy?
Excel can compare a number with thresholds and display a category, but that label is only a general adult screening reference. It cannot assess a person’s overall health or replace an individual clinical interpretation.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.