BMI Calculator for Excel: Formula, Setup, and Tips

Formulas & functions · Updated November 21, 2026

To make a BMI calculator in Excel, enter height in centimeters in A2 and weight in kilograms in B2, then use =IF(OR(A2="",B2="",A2<=0,B2<=0),"",B2/(A2/100)^2) in C2. It calculates body mass index from weight divided by height squared, and leaves the result blank when either measurement is missing or not positive.

What BMI measures

Body mass index, or BMI, is a ratio calculated from a person’s weight and height. It is commonly used as a screening measure to group adult BMI values into broad ranges. It is not a direct measurement of body fat, and it cannot determine a person’s health on its own. An Excel calculator simply performs the arithmetic; it does not make a medical assessment.

The calculation depends on using compatible units. For metric measurements, divide weight in kilograms by height in meters squared. For US customary measurements, a commonly used equivalent is weight in pounds multiplied by 703, divided by height in inches squared. The factor 703 converts the units so the result corresponds approximately to the metric calculation.

For example, a person who is 170 cm tall and weighs 70 kg has a BMI of about 24.2: 70 divided by 1.70 squared. The same result can be calculated using about 67 inches and 154.3 pounds. Small differences can occur if measurements are rounded before entering them.

Set up a simple Excel calculator

In Excel for Microsoft 365 on Windows, create a blank worksheet and add clear column headings. One straightforward layout is:

  • A1: Height (cm)
  • B1: Weight (kg)
  • C1: BMI
  • Enter each person’s measurements in row 2, then put the formula in C2.

After entering the formula, press Enter. To calculate more rows, select C2 and drag its fill handle down the column, or copy and paste the formula into the cells below. Excel adjusts the row references automatically. If you convert the range to an Excel table with Insert > Table, the formula can also fill down as new table rows are added.

Use one unit system consistently within a column. Labeling the headings with units helps prevent someone from entering pounds in a kilograms column or inches in a centimeters column. If several people will use the workbook, include a short note near the inputs explaining what each column expects.

Metric formula and a worked example

For the metric formula above, the assumed layout is height in centimeters in A2 and weight in kilograms in B2. The formula converts centimeters to meters by dividing by 100, squares that height, and divides the weight by the result. The IF and OR checks return a blank when either input is empty or is zero or negative, rather than displaying an error or an implausible result.

With A2 set to 170 and B2 set to 70, the calculation is 70 ÷ (170 ÷ 100)² = 24.2214… . If the cell is displayed to one decimal place, it shows 24.2. To set that display, select the BMI cells and choose Home > Number, then select a number format and set one decimal place. Formatting changes what is displayed, not the underlying precision used in calculations.

Keep the inputs numeric: type 170 for centimeters and 70 for kilograms, not text such as “170 cm” or “70 kg.” Put the units in the column headings instead. Excel may sometimes interpret an entry as text if it includes a unit label, which can prevent arithmetic from working as expected.

US customary units

If your sheet uses inches and pounds, put height in inches in A2 and weight in pounds in B2. Use this formula in C2:

=IF(OR(A2="",B2="",A2<=0,B2<=0),"",703*B2/A2^2)

For a height of 67 inches and a weight of 150 pounds, the result is 703 × 150 ÷ 67², or approximately 23.49. Displayed to one decimal place, it appears as 23.5. The calculation expects total inches, so 5 feet 7 inches should be entered as 67, not as 5.7 or 5’7".

You can keep metric and US-unit calculators on separate worksheet tabs, or add separate input and result columns for each system. Avoid switching units partway down a column unless you also record the unit for every entry and build a deliberate conversion method. A formula cannot infer whether a number such as 70 means kilograms or pounds.

Understanding the result responsibly

For adults, commonly used BMI 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 above. These are population-level screening categories, not personalized targets or diagnoses. A displayed value of 24.9 and one of 25.0 fall on different sides of a category threshold, even though the numerical difference is small.

BMI has important limitations. It does not distinguish fat from muscle or show where body fat is carried. A muscular person may have a high BMI without having the same body-fat level as another person with that BMI. Age, health conditions, and other individual factors also affect how a result should be understood.

Adult categories should not be applied to children and teenagers using the same fixed cutoffs. Their BMI is interpreted in relation to age and sex using appropriate growth references. BMI also needs special consideration during pregnancy and in some clinical circumstances. Anyone concerned about a result should discuss it with a qualified healthcare professional rather than treating a spreadsheet label as a diagnosis.

Make the worksheet easier to use

A small amount of worksheet design can prevent avoidable mistakes. Consider adding a date or an anonymous record identifier if you need to distinguish entries, and keep personal information to the minimum necessary. If the sheet is shared, make the purpose and unit system visible without requiring users to inspect the formulas.

  • Format the input and result columns consistently, and use a clear heading for every measurement.
  • Use data validation to limit accidental text entry where appropriate: select the input cells, then choose Data > Data Validation. A decimal rule can help restrict entries to numbers within a chosen range.
  • Keep formulas in a separate result column and avoid overwriting them with typed values.
  • If you add colors or conditional formatting for BMI ranges, label the categories and state that they are general adult screening ranges, not a health verdict.

Do not choose validation limits as though they were universal medical rules. A range that is reasonable for one worksheet’s purpose may exclude legitimate measurements in another context. The calculator’s job is to calculate consistently; users should decide with appropriate professional guidance how to interpret a result.

Common formula and input problems

A blank result is expected when the formula’s input checks find a blank, zero, or negative measurement. If a result appears when you expect a blank, check whether the input cell contains a space or other text instead of being truly empty. If Excel displays an error, confirm that both entries are numbers and that the formula references the correct cells.

A surprisingly high or low value often points to a unit mix-up. In the metric version, height must be centimeters and weight kilograms; in the US version, height must be inches and weight pounds. Entering 1.70 in a centimeters field, for example, treats the height as 1.70 cm and produces a meaningless result. Likewise, entering pounds into a kilograms field changes the answer substantially.

Check the formula bar if the displayed answer seems rounded too much. A cell formatted to one decimal place may show 24.2 while retaining more digits internally. If you want the calculated value itself rounded, that is a separate choice from display formatting. For most simple calculators, formatting the display is preferable because it preserves precision for later calculations.

When a spreadsheet is and is not a good fit

Excel is useful when you need a transparent calculator, want to process a small set of measurements, or need a result beside other worksheet data. Its formulas are visible and editable, and the workbook can be adapted to add dates, notes, or separate unit systems. The basic formulas work in Microsoft Excel for Microsoft 365 on Windows and use the same arithmetic in Excel for Mac and Excel for the web.

A spreadsheet is less suitable when measurements are being collected as part of clinical care, when a validated system is required, or when sensitive information would be exposed through an improperly shared file. A workbook can be copied, emailed, or stored in a location with broad access. Use appropriate privacy and security practices, and do not treat a local formula as a substitute for a healthcare professional’s assessment.

For a one-off calculation, a reputable online calculator or a calculator app may be quicker. For repeated tracking, Excel can make entries easy to compare over time, but changes in BMI do not explain why weight changed or establish whether a change is beneficial. Consider the measurement context and professional advice rather than focusing only on a trend line.

Frequently Asked Questions

What is the Excel formula for BMI in kilograms and centimeters?
With height in centimeters in A2 and weight in kilograms in B2, use =IF(OR(A2="",B2="",A2<=0,B2<=0),"",B2/(A2/100)^2). It converts height to meters before dividing weight by height squared.

What is the BMI formula for pounds and inches in Excel?
With height in inches in A2 and weight in pounds in B2, use =IF(OR(A2="",B2="",A2<=0,B2<=0),"",703*B2/A2^2). Enter total inches, such as 67 for 5 feet 7 inches.

How many decimal places should I show?
One decimal place is often sufficient for a general display, but it is a presentation choice rather than a change to the BMI method. Use Home > Number to format the result cells; the stored calculation retains its precision.

Can I use adult BMI categories for a child?
No. Adult cutoffs are not the appropriate way to interpret BMI in children and teenagers. Their results require age- and sex-specific growth references, so consult a qualified healthcare professional for interpretation.

Does a BMI result diagnose a health condition?
No. BMI is a screening measure and does not directly measure body fat or account for every relevant personal factor. A clinician can interpret it alongside other information and advise what, if anything, to do next.

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.