BMI Calculator in Excel: Formula and Setup

Formulas & functions · Updated November 21, 2026

To make a BMI calculator in Excel, enter weight in kilograms in B2 and height in metres in C2, then put =B2/(C2^2) in D2. The result is body mass index (BMI); for a U.S. customary version, enter weight in pounds and height in inches and use =703*B2/(C2^2) instead.

What BMI measures

BMI is a screening measure calculated from a person’s weight and height. It is useful for quickly comparing weight relative to height, and a spreadsheet makes it easy to calculate consistently for one person or a list of measurements. BMI is not a direct measurement of body fat, muscle, or overall health, and it cannot diagnose a medical condition by itself.

The calculation is the same each time: divide weight by height squared. The multiplier 703 in the pounds-and-inches version converts the result so it is comparable with the kilograms-and-metres calculation. Do not mix units: using pounds with metres, or kilograms with inches, produces a number that should not be interpreted as BMI.

Set up the worksheet

Start a blank workbook in Microsoft Excel for Microsoft 365 on Windows. Use a clear header row so it is obvious which units the calculator expects. For a metric worksheet, enter these headers:

  • A1: Name or ID
  • B1: Weight (kg)
  • C1: Height (m)
  • D1: BMI

Enter one person’s measurements in row 2. For example, with a weight of 68 kilograms in B2 and a height of 1.65 metres in C2, enter this formula in D2:

With weight in B2 measured in kilograms and height in C2 measured in metres, the BMI formula for row 2 is =B2/(C2^2). It returns approximately 24.98 for those example measurements.

Excel uses the caret symbol, ^, for exponentiation, so C2^2 means height multiplied by itself. Parentheses around the height expression make the intended order clear. Press Enter to calculate, then use the fill handle at the bottom-right corner of D2 to copy the formula into later rows. Each copied formula adjusts its row references automatically.

Choose metric or U.S. customary units

Use one unit system per calculator column. If your data is in pounds and inches, label the columns accordingly, such as Weight (lb), Height (in), and BMI. Put the weight in B2 and height in C2. With those units, the row 2 formula is =703*B2/(C2^2). For 150 pounds and 66 inches, it returns about 24.21.

The two formulas do not give the same answer if the units are entered incorrectly. For example, a height of 1.65 belongs in a metres column, while a height of 65 belongs in an inches column. Use descriptive headers and, if the sheet will be shared, add a note near the inputs stating which units to enter. A blank workbook may otherwise be reused later with the wrong assumptions.

You can also convert measurements before calculating, but for a simple BMI sheet there is usually no need: choosing the matching formula is simpler. If a dataset contains mixed units, standardize it first or add a separate units field and carefully designed conversion logic. Do not apply one formula to a column whose entries use different units.

Build a calculator for multiple rows

For a list, keep one person per row and copy the BMI calculation down the column. A practical layout might include an ID, measurement date, weight, height, and BMI. Dates matter when measurements are repeated because a BMI value describes the weight and height recorded at that time; it is not a permanent attribute.

With metric weights in B2:B20 and metric heights in C2:C20, enter the row 2 calculation in D2 and fill it down through D20. Each row then uses its own weight and height. For a larger table, select the data and choose Insert > Table. Excel tables can extend formulas when you add rows, making ongoing records easier to maintain. Keep only information needed for the spreadsheet’s purpose, especially if it contains personal health measurements.

For a one-person calculator, you can make the worksheet simpler: place labels beside the two input cells, leave a clearly marked result cell, and explain the required units. A compact layout is easier to use, but the units should remain visible. Avoid using cell color alone to communicate what to enter; labels are clearer and more accessible.

Format and check the result

BMI is commonly shown to one decimal place for readability, but the underlying calculation can retain its full precision. Select the BMI cells and use Home > Number to choose a number format or adjust the decimal-place controls. This changes how the value appears, not the stored calculation. Rounding the displayed value is often preferable to rounding intermediate measurements.

For the metric example, the unrounded result is about 24.977. Displayed to one decimal place, it appears as 25.0. The imperial example of 150 pounds and 66 inches is about 24.21, which appears as 24.2 to one decimal place. A difference in displayed decimals does not mean the spreadsheet is using different BMI definitions; it is just a formatting choice.

Check that the result is plausible by testing a known example and confirming the units. If the result is unexpectedly tiny or huge, first inspect the height entry and the formula. A height entered as 165 instead of 1.65 in a metric sheet is a common source of a misleading result.

Interpretation and adult BMI categories

For adults, widely used BMI categories describe a result below 18.5 as underweight, 18.5 to less than 25 as healthy weight, 25 to less than 30 as overweight, and 30 or higher as obesity. These categories are screening ranges, not judgments about an individual and not a diagnosis. A BMI of 25.0, for example, falls at the start of the overweight range in this classification, but that number alone cannot establish a person’s health status.

Do not use the adult categories to interpret children and teenagers. Their BMI is assessed in relation to age and sex using growth charts rather than the adult cutoffs. Pregnancy, substantial muscularity, older age, and some health circumstances can also affect how meaningful a BMI result is. Someone concerned about a result should discuss it with a qualified health professional, who can consider other measurements and personal context.

A spreadsheet can display a category beside a BMI, but an automated label may make the result seem more definitive than it is. If you add categories, state that they apply to adults and are general screening ranges. Do not use the spreadsheet as a substitute for clinical assessment or as the sole basis for a health decision.

Common spreadsheet problems

  • Wrong units: Check the column headers and use the metric formula only for kilograms and metres, or the 703 formula only for pounds and inches.
  • Height entered in centimetres: The metric formula expects metres. Convert centimetres to metres before entering the value, or use a separate, clearly labeled conversion step.
  • Blank or zero values: A blank input may make the result look like zero, while a zero height causes a division error. Enter realistic positive measurements before reading the result.
  • Formula copied incorrectly: Check that each row refers to the weight and height on that same row. When copying formulas, Excel normally adjusts relative references automatically.
  • Result appears as a date or odd format: Select the result cells and apply a number format from Home > Number.

Excel may also show a formula as text if the cell is formatted as Text or the entry begins with an apostrophe. Change the cell format to General, re-enter the formula, and press Enter. If formulas are visible in many cells instead of results, check whether Show Formulas is enabled on the Formulas tab.

Make the sheet easier to use

Use bold headers and freeze the top row if the list is long; in Excel for Windows, choose View > Freeze Panes > Freeze Top Row. Add a short instruction line explaining units and the meaning of the result. If other people will enter data, Excel’s Data Validation feature can help restrict entries: select the input cells and choose Data > Data Validation. A decimal-number rule can discourage text or implausible entries, but it cannot confirm that a measurement is accurate.

Conditional formatting can highlight values, but use it cautiously. For example, color coding adult screening ranges can be confusing if the sheet includes children or does not explain the categories. If you choose to add visual cues, keep the category labels visible and include a note about their limitations. In Excel for Mac, the ribbon and available dialog details can differ slightly, but the worksheet formulas are the same; Excel for the web also supports the basic formulas and number formatting described here.

When a spreadsheet is not enough

An Excel calculator is convenient when you want a transparent, editable calculation, need to record multiple dates, or want to learn how the formula works. It does not need an internet connection once the workbook is saved, and the formula can be inspected directly. For occasional use, however, a reputable online calculator or a calculator supplied by a health service may be quicker and may explain the limitations alongside the result.

Choose a different tool when you need interpretation for children, clinical records, or a broader assessment involving other health information. A generic spreadsheet formula is not a child growth chart, and adding more formulas does not turn it into a medical assessment. Keep the Excel sheet focused on calculation and recordkeeping, and seek professional advice for questions about what a result means for a particular person.

Frequently Asked Questions

What is the BMI formula in Excel?
For weight in kilograms in B2 and height in metres in C2, use =B2/(C2^2). For pounds in B2 and inches in C2, use =703*B2/(C2^2). Keep the units consistent with the selected formula.

How do I calculate BMI using pounds and inches?
Divide weight in pounds by height in inches squared, then multiply by 703. In Excel, if weight is in B2 and height is in C2, enter =703*B2/(C2^2) in the BMI cell.

How many decimal places should a BMI calculator show?
One decimal place is an easy-to-read display choice, though retaining more precision in the underlying value is fine. Use number formatting if you only want to change the display; it does not alter the calculation.

Can I use adult BMI ranges for a child?
No. Adult BMI category cutoffs are not the appropriate way to interpret a child or teenager’s BMI. Children’s results are evaluated using age- and sex-specific growth references, so ask a qualified health professional for interpretation.

Why does my Excel BMI result look wrong?
Check the units, especially whether height is in metres or inches, and confirm that the formula points to the correct cells. Also check that height is a positive number and that the result cell is formatted as a number rather than text or a date.

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.