To calculate BMI in Excel, divide weight in kilograms by height in metres squared. If weight is in A2 in kilograms and height is in B2 in centimetres, enter =IF(AND(ISNUMBER(A2),ISNUMBER(B2),A2>0,B2>0),A2/((B2/100)^2),"") in C2; for 70 kg and 175 cm, it returns about 22.9. The formula leaves the result blank until both inputs are positive numbers.
What BMI measures
Body mass index, or BMI, is a screening measure calculated from a person’s weight and height. The same mathematical relationship is used whether you enter metric or imperial measurements; only the conversion differs. BMI is useful in spreadsheets because it is straightforward to calculate consistently across a list of records.
BMI does not directly measure body fat, muscle, or overall health. It compares weight with height using a population-level measure, so a result is best understood as a screening indicator rather than an individual diagnosis. Excel can do the arithmetic, but it cannot account for a person’s age, body composition, medical history, or other factors that influence health.
Set up your Excel columns
Start with clear column labels so the units are visible and cannot be confused. For a metric sheet, use a layout such as this:
- A1: Weight (kg)
- B1: Height (cm)
- C1: BMI
Enter one person or measurement per row, beginning in row 2. Keep units consistent down each column: do not mix kilograms and pounds in the weight column, or centimetres and inches in the height column. If the sheet will be shared, include the units in the headings and consider adding a note that the BMI formula is intended for adults.
For a single calculation, type the formula directly into C2. For a list, fill it down the BMI column. In Excel for Microsoft 365 on Windows, select C2 and drag its fill handle—the small square at the lower-right corner of the cell—down the rows. You can also copy C2, select the destination cells, and press Ctrl+V. Excel adjusts the row references automatically. On Mac, the corresponding copy shortcut is Command+V; the formula itself is the same. Excel for the web also supports the calculation.
Metric BMI formula for Excel
The metric calculation is weight in kilograms divided by height in metres squared. When height is recorded in centimetres, divide it by 100 to convert it to metres before squaring it. With weight in A2 as kilograms and height in B2 as centimetres, put this formula in C2:
=IF(AND(ISNUMBER(A2),ISNUMBER(B2),A2>0,B2>0),A2/((B2/100)^2),"")
The AND test checks that both cells contain numbers greater than zero. If an input is blank, text, zero, or negative, the formula returns an empty string rather than attempting the BMI calculation. For 70 kg and 175 cm, the arithmetic is 70 divided by 1.75 squared, or 70 ÷ 3.0625 = 22.857142… . Excel displays the unrounded result unless you change the cell’s number format.
If height is already entered in metres, use a simpler formula. With weight in kilograms in A2 and height in metres in B2, enter this in C2:
=IF(AND(ISNUMBER(A2),ISNUMBER(B2),A2>0,B2>0),A2/(B2^2),"")
For 70 kg and 1.75 m, this also returns 22.857142… . Do not use the centimetre version if the height is already in metres; dividing 1.75 by 100 would produce a wildly incorrect result.
Imperial BMI formula
For pounds and inches, the commonly used imperial formula is BMI = 703 × weight in pounds ÷ height in inches squared. The factor 703 converts the units so the result is comparable to the metric BMI value. If A2 contains pounds and B2 contains inches, enter this formula in C2:
=IF(AND(ISNUMBER(A2),ISNUMBER(B2),A2>0,B2>0),703*A2/(B2^2),"")
For 160 lb and 70 in, the calculation is 703 × 160 ÷ 70² = 112,480 ÷ 4,900, or about 22.955. The result is approximately 23.0 when displayed to one decimal place. This is a common approximation of the conversion factor; small differences in the final decimal can occur depending on the factor and rounding used.
If your source data uses feet and inches, convert the height to a single inches value before applying the formula. For example, 5 feet 10 inches equals 70 inches. Entering 5.83 as though it were inches, or using 5.10 to mean 5 feet 10 inches, will not produce a valid height for this calculation.
Display results and fill the formula down
BMI is often shown to one decimal place for readability, but it is usually better to keep the full calculated value in the cell and change only how it is displayed. Select the BMI cells, then use Home > Number and choose the Increase Decimal or Decrease Decimal buttons until one decimal place is shown. You can also right-click the selection, choose Format Cells, and set the number of decimal places. On Mac, the ribbon layout can differ slightly, but the number-format controls are available in Excel.
For example, the metric calculation for 70 kg and 175 cm is 22.857142… . Displaying one decimal place shows 22.9 without changing the underlying value. That matters if you later compare values to category boundaries or use the BMI in another formula: rounding the displayed number does not change the calculation stored in the cell.
If you specifically need a rounded value in a separate cell, with the unrounded BMI in C2, enter this in D2:
=ROUND(C2,1)
This returns 22.9 when C2 contains 22.857142… . Unlike number formatting, ROUND changes the value returned by the formula. Keep the original BMI if later calculations need its full precision.
Optional adult BMI categories
You can add a text category beside the BMI, but treat it as a reference label rather than a diagnosis. For adults, commonly used BMI ranges are under 18.5, 18.5 to less than 25, 25 to less than 30, and 30 or above. With the calculated adult BMI in C2, enter this formula in D2:
=IF(C2="","",IF(C2<18.5,"Underweight",IF(C2<25,"Healthy weight",IF(C2<30,"Overweight","Obesity"))))
For a BMI of 22.9, the formula returns Healthy weight. The use of less-than comparisons means a value of exactly 25 is placed in the Overweight category and a value of exactly 30 in the Obesity category. These are standard adult screening bands; they are not a statement about a particular person’s health. If the formula is copied down, Excel will refer to C3, C4, and so on automatically.
Do not apply these adult categories to children or teenagers. BMI interpretation for younger people generally depends on age and sex as well as the BMI value, and uses age-specific reference methods. Pregnancy and certain athletic or clinical circumstances also require more context than this basic formula provides.
Common spreadsheet problems
When a result looks implausible or Excel displays an error, check the input units and cell contents before changing the formula. Typical causes include:
- Wrong height unit: The metric formula above expects centimetres, not metres. If the cell contains 1.75, use the metres formula instead.
- Mixed units: A column containing both kilograms and pounds cannot be processed correctly by one formula without first converting the entries to one unit.
- Feet-and-inches entry: Convert the combined height to inches, such as 5 feet 10 inches to 70 inches, before using the imperial formula.
- Text instead of numbers: An entry such as “70 kg” may be stored as text. Put the numeric value 70 in the weight cell and put kg in the column heading.
- Zero or missing measurements: Height must be positive, and missing values cannot produce a meaningful BMI. The metric and imperial formulas above return a blank when either input is missing or invalid.
- Unexpected decimal separators: Excel’s regional settings can affect how decimals and formula separators are entered. If Excel rejects a formula, check the separators used by your installation rather than altering the calculation.
Also check that formulas were copied to the intended rows and that the BMI column is formatted as a number, not as a date or percentage. A percentage format can make an ordinary BMI appear dramatically larger than expected, even though the underlying calculation is correct.
What a BMI result can and cannot tell you
A BMI value is a weight-to-height ratio, not a direct estimate of body-fat percentage. It does not distinguish fat mass from muscle or bone mass, and it does not show where weight is carried. Two people with the same BMI can therefore have different body compositions and different health circumstances. A spreadsheet result should not be used on its own to judge whether someone is healthy or to make treatment decisions.
For adults, the commonly used categories can help describe broad ranges, but interpretation may depend on factors such as age, pregnancy, health conditions, and population-specific guidance. For children and teenagers, adult cutoffs are not appropriate. If a result raises a health question, discuss it with a qualified health professional who can interpret it alongside other relevant information.
For an individual, other measures or assessments may offer different information, but they have their own limitations and should be selected for a clear purpose. The useful role of an Excel BMI sheet is usually modest: calculate the ratio consistently, document the units, and make the limits of the measure clear to anyone reading the result.
Frequently Asked Questions
What is the exact BMI formula in Excel?
For kilograms in A2 and centimetres in B2, the basic calculation is =A2/((B2/100)^2). The longer formula earlier in this article adds checks so blank, nonnumeric, or nonpositive inputs return a blank instead of a calculated value.
Can Excel calculate BMI from pounds and inches?
Yes. With pounds in A2 and inches in B2, use =703*A2/(B2^2). The formula assumes the height is a total number of inches, not feet or a feet-and-inches entry.
Why is my Excel BMI result so high?
Check whether the formula expects centimetres but the height was entered in metres, or whether pounds and inches were mixed with the metric formula. Also confirm that the BMI cell is not formatted as a percentage and that the height is a numeric value in the expected unit.
Should I round BMI in the formula?
Usually, format the cell to show one decimal place and retain the full calculated value. Use ROUND only when a rounded value is specifically required for a report or downstream calculation; rounding can affect comparisons near a category boundary.
Can I use adult BMI categories for a child?
No. Adult category cutoffs should not be used to interpret a child’s or teenager’s BMI. Age- and sex-specific interpretation is generally needed, so consult an appropriate clinical resource or health professional for that context.
Does a healthy-range BMI prove someone is healthy?
No. BMI is a screening measure and cannot establish overall health or diagnose a condition. Its result needs to be considered with other relevant information and, when needed, professional guidance.
Related
- Excel for Numerical Analysis: Uses, Limits, and Tips
- Excel Historical Sales Analysis: Find Trends and Patterns
- Excel Financial Analysis: Methods, Models, and Metrics
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel COUNTIF for Red Text: What WorksExcel’s COUNTIF function cannot count cells by red font color: COUNTIF checks cell values, not formatting. To count…
- Excel Formula Showing Instead of Result? Causes and FixesIf Excel is showing a formula instead of its result, first check whether Show Formulas is turned on;…
- Excel SORT and INDEX: How to Sort Data and Return ValuesTo sort a range in Excel for Microsoft 365, use =SORT(A2:C6,3,-1) to sort its rows by the third…
- Transpose Data in Excel Using a Formula Step by StepTo transpose data in Excel with a formula, select a blank cell where the transposed result should begin…
- Excel Days Until Due: Formula, Date Math, and Alerts ExplainedTo calculate days until a due date in Excel, put the due date in A2 and enter =A2-TODAY()…
- Excel Timesheet Formula Minus Lunch: Simple ExamplesTo subtract an unpaid lunch entered as minutes, put the shift start in B2, the end in C2,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.