To calculate BMI in Excel, divide weight in kilograms by height in meters squared. If weight is in B2 and height in centimeters is in C2, enter =B2/((C2/100)^2) in D2; for 70 kg and 175 cm, the result is about 22.9. The sections below show metric and imperial formulas, a useful worksheet layout, category labels, and ways to avoid common spreadsheet errors.
What BMI measures—and what it does not
Body mass index (BMI) is a ratio of body weight to height. It is a screening measure commonly used to group adult results into ranges; it is not a direct measurement of body fat and does not diagnose a health condition. The standard metric calculation is weight in kilograms divided by height in meters squared. Because height is squared, the same weight produces a lower BMI at a greater height.
Excel can calculate the arithmetic quickly, but the number needs context. BMI does not distinguish fat from muscle, show where body fat is carried, or account for every difference in age, sex, health, or body composition. A spreadsheet can help organize calculations, but a BMI result by itself should not be treated as a complete assessment of an individual’s health.
Set up a simple BMI worksheet
A clear layout makes it easier to enter, check, and reuse measurements. In row 1, use headings such as Name, Weight (kg), Height (cm), BMI, and Adult category. Put the first person’s information in row 2, then place the calculation in the BMI column. For example, the formula below assumes weight in B2 and height in centimeters in C2; with 70 in B2 and 175 in C2, it returns approximately 22.86.
With weight in kilograms in B2 and height in centimeters in C2, enter this in D2: =B2/((C2/100)^2)
The calculation converts the centimeter entry to meters before squaring it: 175 cm becomes 1.75 m, and 70 divided by 1.75 squared is approximately 22.86. To use the same calculation for more rows, select D2 and drag the fill handle down, or copy and paste the formula into the cells below. Excel adjusts the row references automatically, so the next row will use B3 and C3.
Use centimeters or meters correctly
Choose a height unit deliberately. The formula above expects centimeters and divides the entry by 100. If your height data is already stored in meters, do not convert it again. For example, with weight in kilograms in B2 and height in meters in C2, enter this in D2; for 70 kg and 1.75 m, the result is approximately 22.86.
With weight in kilograms in B2 and height in meters in C2, use: =B2/(C2^2)
A frequent mistake is putting 175 in a formula that expects meters, or entering 1.75 in one that expects centimeters. Both produce a misleading result. Give the unit in each column heading, and keep one unit convention for all rows in a calculation column. If incoming records use mixed units, standardize them in separate columns before calculating BMI rather than guessing what an entry means.
Calculate BMI from pounds and inches
For measurements in the customary U.S. units, the commonly used formula is BMI = 703 × weight in pounds ÷ height in inches squared. The factor 703 converts the units so that the result corresponds approximately to the metric BMI calculation. With weight in pounds in B2 and height in inches in C2, enter the following formula in D2. For 154 lb and 70 in, it returns about 22.09, or 22.1 when rounded to one decimal place.
With pounds in B2 and inches in C2, enter in D2: =703*B2/(C2^2)
Do not use the factor 703 with kilograms or centimeters; it is for pounds and inches. Likewise, do not enter a height in feet alone. Convert it to inches first: for example, 5 feet 10 inches is 70 inches. If your data has feet in one column and inches in another, either calculate a total-inches helper column or combine the values in the BMI formula, making sure the inches are added rather than treated as a decimal fraction of a foot.
Round the displayed result
For readability, a BMI table often displays one decimal place. Rounding changes the displayed precision, not the underlying meaning or accuracy of the measurements. A useful approach is to retain the full calculated value in the BMI cell and set the cell’s number format to one decimal place. In Excel for Microsoft 365 on Windows, select the cells and use Home > Number to choose a number format or adjust decimal places. The same formula works in Excel for Mac and Excel for the web, although ribbon appearance can differ.
If you want the formula itself to return a one-decimal value, the following assumes weight in kilograms in B2 and height in centimeters in C2; 70 and 175 return 22.9.
With weight in B2 and height in centimeters in C2, enter in D2: =ROUND(B2/((C2/100)^2),1)
For most recordkeeping, formatting the cell rather than rounding the stored result is preferable. Excel can then use the unrounded value in later calculations. This distinction can matter near a category cutoff: a displayed value such as 25.0 may be based on a value just below or just above 25. Use the underlying value when applying thresholds, not a rounded display alone.
Add an adult BMI category label
For adults, commonly used screening 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 category labels for interpreting adult BMI, not diagnoses. If the calculated BMI is in D2, this formula in E2 returns a matching label; if D2 is blank, it leaves the category blank.
With the BMI result in D2, enter this in E2: =IF(D2="","",IF(D2<18.5,"Underweight",IF(D2<25,"Healthy weight",IF(D2<30,"Overweight","Obesity"))))
The order of the tests matters: Excel checks the first condition, then proceeds to the next only if the earlier condition is false. The formula assigns exactly 18.5 to Healthy weight, exactly 25 to Overweight, and exactly 30 to Obesity. Copy it down alongside the BMI formula to label additional rows. If a workplace, clinic, or published source specifies a different classification system, use that source’s definitions rather than silently substituting these adult ranges.
Prevent blank inputs and invalid results
A zero or missing height makes BMI impossible to calculate, and negative measurements are not valid inputs. A blank cell can otherwise lead to a misleading zero or a division error, depending on the formula. To leave the BMI cell empty until both measurements are positive, use a check before calculating. This version assumes weight in B2 and height in centimeters in C2; with valid entries of 70 and 175, it returns approximately 22.86, while a blank or nonpositive measurement returns an empty string.
With weight in B2 and height in centimeters in C2, enter in D2: =IF(OR(B2="",C2="",B2<=0,C2<=0),"",B2/((C2/100)^2))
This formula handles blanks and values that are zero or below zero. It does not make text such as “175 cm” a numeric measurement; that entry can produce an error. Enter numbers only and identify units in the column heading. To reduce accidental text entries, Excel for Microsoft 365 on Windows provides Data > Data Validation, where you can set an input rule such as a decimal greater than zero. Validation is a helpful guardrail, not a substitute for checking imported or pasted data.
Check units, references, and results
When an answer looks implausible, check the inputs before changing the formula. Common causes include:
- Mixed units: a height in inches may have been entered into a centimeters column, or a weight in pounds into a kilograms column.
- Wrong cell references: confirm the formula points to the weight and height cells on the same row.
- Text instead of numbers: remove unit text from measurement cells and use headings to identify units.
- Missing or zero height: confirm the height is present and greater than zero.
- Unexpected decimal separators: Excel’s regional settings can affect how decimal numbers are entered. Use the separator expected by the installation and check that the cell is stored as a number.
A quick independent check is to calculate the example outside the spreadsheet. For 70 kg and 175 cm, convert height to 1.75 m; 1.75 × 1.75 = 3.0625, and 70 ÷ 3.0625 is about 22.86. If Excel shows a very different result, inspect the formula bar and the original cell values. Also check whether a cell format is hiding decimals or displaying a date or percentage format.
Interpreting results and choosing the right use
Adult BMI categories are population-level screening ranges. The standard categories generally should not be applied to children and teenagers in the same way: interpretation for ages 2 through 19 uses BMI-for-age percentiles that account for age and sex, rather than the adult cutoffs. A simple adult-category formula in Excel is therefore not suitable for classifying a child. Pregnancy, athletic builds, older age, and some health circumstances can also affect how useful BMI is as an individual measure.
Use a BMI spreadsheet for arithmetic, educational examples, or consistent organization of measurements—not as a stand-alone diagnosis or treatment guide. If a result raises concern, or you need to interpret BMI for a child or a person with a specific health situation, consult a qualified healthcare professional. Measurements can also vary with scale accuracy, clothing, posture, and how height is recorded; recording consistent measurement methods makes comparisons more useful.
Frequently Asked Questions
What is the Excel formula for BMI in kilograms and centimeters?
With weight in kilograms in B2 and height in centimeters in C2, use =B2/((C2/100)^2). The formula converts height to meters and divides weight by height squared. For 70 kg and 175 cm, the result is approximately 22.86.
What is the Excel formula for BMI in pounds and inches?
With weight in pounds in B2 and height in inches in C2, use =703*B2/(C2^2). The 703 factor accounts for the different units. Do not use this formula with metric measurements.
How do I calculate BMI if my height is in meters?
With weight in kilograms in B2 and height in meters in C2, use =B2/(C2^2). For example, 70 kg and 1.75 m produce approximately 22.86.
Should I round BMI in Excel?
Displaying one decimal place is convenient, but keeping the underlying result unrounded helps preserve precision for comparisons and category checks. You can format the cell to show one decimal place or use the ROUND function when a rounded value is specifically needed.
Can I use adult BMI categories for a child?
No. Adult cutoffs are not the appropriate classification method for children and teenagers. Their BMI is interpreted using age- and sex-specific percentiles, so use a suitable clinical reference or ask a healthcare professional rather than relying on an adult category formula.
Related
- Excel Financial Analysis: Methods, Models, and Metrics
- Excel Export CSV With Headers: How It Works
- Excel Export CSV With Quotes: How It Works
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Remove Duplicates in Excel: Sort Data the Right WayTo remove duplicates in Excel and keep the right record, sort your data first if the order determines…
- Excel Cell Value From List: Find or Select a MatchTo return a value from a list when you know a matching item, use XLOOKUP; with product IDs…
- Excel Unique Dropdown List: Create One That UpdatesTo create a unique dropdown list in Excel for Microsoft 365, generate a deduplicated list with UNIQUE, then…
- Excel Sort Multiple Columns: Rules, Steps, and TipsTo sort Excel data by multiple columns, select a cell in the data, choose Data > Sort, then…
- Excel Protect Sheet: Allow Users to Filter and SortYes. In Excel for Microsoft 365 on Windows, turn on the filter before protecting the worksheet, then choose…
- Split Numbers and Text in Excel With FormulasYes. With mixed values such as AB-123 in A2, Excel for Microsoft 365 can extract the digits with…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.