To calculate BMI in Excel, divide weight in kilograms by height in metres squared. If weight is in B2 and height in metres is in C2, enter =B2/(C2^2) in D2. For pounds and inches, use a different formula: =703*B2/(C2^2), assuming weight in pounds is in B2 and height in inches is in C2.
Set Up Your BMI Worksheet
A simple worksheet needs one row per person or measurement and separate columns for weight, height, and the calculated result. For example, put a name or record label in column A, weight in B, height in C, and BMI in D. Add units to the headings so it is clear whether a value is kilograms or pounds and whether a height is metres, centimetres, or inches.
For a metric worksheet, a useful header row is “Name,” “Weight (kg),” “Height (m),” and “BMI.” Enter the first measurement on row 2, then place the formula in D2. If the height is recorded in centimetres rather than metres, you can use a formula that converts the height within the calculation. With weight in kilograms in B2 and height in centimetres in C2, enter =B2/((C2/100)^2) in D2. For example, 70 kg and 175 cm produces a BMI of about 22.9.
Use one consistent unit system for each calculation. A column of weights should not mix kilograms and pounds, and a height column should not mix metres, centimetres, and inches. Excel stores these entries as numbers; it does not infer or convert units just because a heading says “kg.”
Use the Metric BMI Formula
The standard metric calculation is weight in kilograms divided by height in metres multiplied by itself. In spreadsheet terms, the exponent operator ^ squares the height. The parentheses in the formula make Excel calculate the squared height as the denominator, rather than dividing by height first and squaring the result.
For a worked example, suppose the weight is 70 kg and the height is 1.75 m. The height squared is 3.0625, and 70 divided by 3.0625 is approximately 22.857. The cell can display 22.9 when formatted to one decimal place, while Excel retains the underlying precision for further calculations.
If your height is entered in centimetres, either convert it to metres in a separate column or use the centimetre version of the formula above. A height of 175 cm becomes 1.75 m. Mixing centimetres directly into the metres formula would produce a dramatically incorrect result because the height would be treated as 175 metres.
Calculate BMI With Pounds and Inches
For US customary measurements, the commonly used calculation multiplies weight in pounds by 703, then divides by height in inches squared. With weight in pounds in B2 and height in inches in C2, enter =703*B2/(C2^2) in D2. The factor 703 adjusts the result so it corresponds to the metric BMI scale; it is not a percentage or a rounding adjustment.
For example, a person weighing 154 pounds and measuring 68 inches has a BMI of about 23.4 using this formula. The calculation is 703 multiplied by 154, divided by 68 squared. Do not enter height as feet alone: convert the full height to inches first. Someone who is 5 feet 8 inches tall is 68 inches, not 5.8 inches or 5.8 feet.
If your source data uses feet and inches in separate columns, convert the entries to total inches before calculating BMI. With feet in B2 and additional inches in C2, a conversion can be made in a helper column. Assuming those two cells hold the feet and remaining inches, enter =B2*12+C2 in D2 to get total inches. Then calculate BMI using the weight and the total-inches cell. Keeping the conversion visible makes the worksheet easier to check.
Enter the Formula and Fill It Down
In Excel for Microsoft 365 on Windows, select the first BMI result cell, type the appropriate formula, and press Enter. To apply it to more rows, select the formula cell and drag its fill handle—the small square at the lower-right corner—down the column. Excel adjusts ordinary cell references for each row, so a formula that refers to B2 and C2 will refer to B3 and C3 on the next row.
You can also copy the formula cell and paste it into the cells below. If the range is formatted as an Excel table, typing a formula in the first data row of a new column will often fill the calculated column automatically. Tables are useful for growing lists because they keep headings attached to the data and make sorting or filtering records more convenient.
Excel for Mac and Excel for the web use the same BMI formulas and cell-reference logic. The layout of the ribbon or the way you reach some formatting controls can differ, but the formulas shown here work in those versions as well. If your Excel installation uses semicolons rather than commas in formulas, that is a regional list-separator setting; the BMI formulas above have no argument separators, so they are unaffected.
Format Results and Add an Adult Category
By default, Excel may show many decimal places or a rounded-looking value, depending on the cell format. To make results readable, select the BMI cells and use Home > Number to set the number of decimal places, or choose a number format that displays one decimal place. Formatting changes what is displayed, not the stored value. That distinction matters if you later classify results near a category boundary.
You can add a text category in a separate column, based on adult BMI cutoffs. Assuming the unrounded BMI is in D2, enter this formula in E2: =IF(D2<18.5,"Underweight",IF(D2<25,"Healthy weight",IF(D2<30,"Overweight","Obesity"))). It returns “Healthy weight” for the 70 kg, 1.75 m example, whose BMI is about 22.9. Copy the formula down to label other rows.
These 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. The category formula uses the original BMI value in D2, not the one-decimal display. That prevents display rounding from changing the classification. If you prefer conditional formatting to make values easier to scan, select the BMI range and use Home > Conditional Formatting to apply rules, but colors should supplement—not replace—the displayed number and category.
Check Inputs and Avoid Common Errors
A spreadsheet will calculate a result even when an input is unsuitable, so check the data as well as the formula. A blank height can lead to a divide-by-zero error, text pasted into a measurement cell can prevent a calculation, and a zero or negative height is not a valid measurement. Unexpectedly extreme results often point to a unit mix-up, a misplaced decimal point, or a formula copied from the wrong row.
- Check units and headings before entering a batch of measurements.
- Confirm that heights are recorded consistently, especially when converting feet and inches or centimetres and metres.
- Inspect a few rows manually by repeating the calculation with a calculator.
- Keep the original measurement columns so that a result can be traced back to its inputs.
- Do not replace an error with zero; find and correct the missing or invalid input instead.
For a more controlled sheet, you can restrict entries with Excel’s Data Validation feature. Select the intended input cells and choose Data > Data Validation, then set an appropriate rule such as allowing decimal numbers greater than zero. Validation can reduce accidental text or negative values, but it cannot determine whether a measurement is realistic for a particular person. Review the units and records yourself.
Understand What a BMI Result Means
BMI is a screening measure calculated from weight and height. It can help describe weight relative to height across populations, but it does not directly measure body fat, its distribution, or overall health. Two people with the same BMI can differ in muscle mass, age, health conditions, and other factors. A spreadsheet gives the arithmetic result; it does not provide a diagnosis or a complete assessment of health.
The adult category ranges are not interpreted the same way for children and teenagers. For those groups, BMI is assessed in relation to age and sex using growth references, rather than by applying the adult cutoffs in the category formula above. Do not use the adult label formula for a child and treat its result as a clinical classification.
For adults, a result near a threshold should not be treated as a sharp boundary between health states. Rounding, measurement error, and individual circumstances all matter. If a BMI result raises a concern or will be used to make a health decision, discuss it with a qualified health professional who can consider more than height and weight.
Frequently Asked Questions
What is the Excel formula for BMI in kilograms and metres?
If weight in kilograms is in B2 and height in metres is in C2, enter =B2/(C2^2) in the result cell. For instance, 70 kg and 1.75 m gives approximately 22.9.
How do I calculate BMI in Excel using centimetres?
With weight in kilograms in B2 and height in centimetres in C2, enter =B2/((C2/100)^2). Dividing the centimetre measurement by 100 converts it to metres inside the calculation.
How do I calculate BMI using pounds and inches?
With weight in pounds in B2 and height in inches in C2, enter =703*B2/(C2^2). Convert a height written in feet and inches to total inches before using the formula.
How many decimal places should BMI show in Excel?
One decimal place is usually readable for a worksheet, but changing the number format only changes the display. Keep the full calculated value for any category formula so rounding does not alter a result near a cutoff.
Can Excel tell me whether my BMI is healthy?
Excel can compare a number with thresholds you enter, but that comparison is not a diagnosis. Adult ranges are not the right classification method for children and teenagers, and BMI alone cannot account for an individual’s full health context.
Related
- Excel RAG Analysis: Build a Red-Amber-Green Tracker
- Excel Profit Analysis Tool: Build One Step by Step
- Excel Predictive Analysis: Methods, Steps, and Limits
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Round Up to Dollar: 4 Easy WaysTo round a number up to the nearest whole dollar in Excel, use the ROUNDUP function with 0…
- Calculate a Weighted Average in Excel: Formula and ExamplesTo calculate a weighted average in Excel, multiply each value by its weight, add those products, and divide…
- Arduino String Functions: Methods, Examples, and TipsArduino string functions are methods for working with text stored in the Arduino String class: for example, length()…
- IFERROR in Excel: Leave Blank When a Formula ErrorsTo make an Excel formula show a blank instead of an error, wrap it in IFERROR and use…
- Excel Named Ranges: Formulas That WorkYes, you can use formulas inside named ranges in Excel, but with a key distinction: a named range…
- Excel SUM Formula Returns 0? Causes and FixesIf an Excel SUM formula returns 0, first check whether its referenced cells contain real numbers and whether…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.