BMI Calculation in Excel: Formula and Setup

Formulas & functions · Updated November 21, 2026

To calculate BMI in Excel using metric units, enter height in centimetres in A2 and weight in kilograms in B2, then use =B2/(A2/100)^2 in C2. For example, 170 cm and 70 kg returns a BMI of about 24.22; the same worksheet can use a separate formula for pounds and inches.

What the BMI calculation measures

BMI, or body mass index, is a screening measure that relates a person’s weight to their height. The metric calculation divides weight in kilograms by height in metres multiplied by itself. Since height in the example is entered in centimetres, the Excel formula converts it to metres by dividing by 100 before calculating the result.

BMI is a ratio, not a direct measurement of body fat. It does not distinguish fat from muscle, identify where fat is carried, or account for every factor that affects health. Its value is that it provides a simple, repeatable measure that can help put weight in context alongside other health information. A spreadsheet can calculate the number accurately, but it cannot determine what that number means for an individual.

Set up a metric BMI worksheet

Use a clear header row so that anyone entering data can tell which units the worksheet expects. For example, put Height (cm) in A1, Weight (kg) in B1, and BMI in C1. Enter a person’s height and weight in row 2, then enter the formula in C2. The formula assumes height is in centimetres and weight is in kilograms; swapping the columns or entering metres instead of centimetres changes the result.

For the layout with height in centimetres in A2 and weight in kilograms in B2, enter =B2/(A2/100)^2 in C2. With A2 set to 170 and B2 set to 70, the result is 24.22145, or approximately 24.22. The arithmetic is 70 divided by 1.7 squared. Copy the formula down column C to calculate BMI for additional rows; Excel adjusts the row references as it fills down.

In Microsoft Excel for Microsoft 365 on Windows, you can type the formula directly into the cell or select C2, type it in the formula bar, and press Enter. If the worksheet has a header row and records begin in row 2, keeping each person’s height, weight, and result together on the same row makes the sheet easier to check and sort.

Calculate BMI with pounds and inches

If the measurements are in US customary units, use weight in pounds and height in inches. The standard conversion factor in the BMI calculation is 703. It accounts for converting pounds and inches to the units used by the metric version, so there is no need to convert the input cells first.

For a layout with height in inches in A2 and weight in pounds in B2, enter =703*B2/(A2^2) in C2. For a height of 68 inches and a weight of 154 pounds, the result is approximately 23.41: 703 multiplied by 154, divided by 68 squared. Label the columns Height (in) and Weight (lb), rather than simply Height and Weight, to reduce the risk of mixing units.

Metric and imperial inputs should not share one formula unless the worksheet also identifies which units are being used and selects the appropriate calculation. For a simple personal or classroom sheet, separate tabs or clearly marked sections are safer. A number such as 170 could mean centimetres or inches, and Excel cannot infer the intended unit from the value alone.

Format and fill the results

BMI is commonly displayed to one or two decimal places. The underlying result can retain more precision while the cell display is rounded, which is useful if later calculations depend on it. Select the result cells and use the decimal-place controls in the Home tab’s Number group, or open Format Cells and choose a number format. Avoid formatting the result as a percentage: BMI is not a percentage.

Once C2 contains the metric or imperial formula, copy it to the rows below. You can drag the fill handle at the lower-right corner of the selected cell, or copy and paste into the destination cells. For a larger data range, convert the range to an Excel table with Insert > Table; formulas entered in a table column generally fill down automatically as new rows are added. Keep a blank row or a clear heading between unrelated datasets so that a formula is not accidentally copied into the wrong section.

Do not type a rounded BMI back over the formula result. If you need a number rounded for display, use cell formatting; if a downstream calculation specifically requires a rounded value, create a separate column and document why it is rounded. Keeping the original calculation intact makes it easier to review or change the display later.

Check inputs and prevent common errors

The most frequent mistakes are unit mismatches, a height entered in the wrong scale, and references to the wrong cells. A height of 1.70 belongs in a formula designed for metres, not the centimetres-based formula above; entering 1.70 as centimetres would produce a wildly inflated result. Likewise, entering kilograms into a pounds-based formula gives an incorrect BMI even though Excel displays a valid-looking number.

Before trusting a result, check these details:

  • Confirm that the height and weight headings include units.
  • Check that the formula references the height and weight cells on the same row.
  • Look for values stored as text, stray spaces, or punctuation that Excel cannot interpret as numbers.
  • Verify that height is positive and plausible and that weight is positive.
  • Compare one row with a hand calculation or a trusted calculator to catch a copied formula with an incorrect reference.

A #DIV/0! error usually means the height cell is blank or zero. A #VALUE! error may indicate that one of the inputs is text rather than a numeric value. If you want blank inputs to leave the result cell blank, use an adjusted formula. For the same metric layout—height in centimetres in A2 and weight in kilograms in B2—enter =IF(OR(A2="",B2=""),"",B2/(A2/100)^2) in C2. This prevents an output while either input is empty, but it does not validate implausible values or replace checking the data.

Interpret adult BMI ranges carefully

For adults, widely used categories classify BMI below 18.5 as underweight, from 18.5 to below 25 as healthy weight, from 25 to below 30 as overweight, and 30 or above as obesity. These are category boundaries for a screening measure, not diagnoses or guarantees about an individual’s health. A value near a boundary can shift category with a small change in measured height or weight, so it is sensible not to imply more precision than the measurements support.

Adult categories should not be applied to children and teenagers. Their BMI is interpreted in relation to age and sex using growth references, rather than by applying the standard adult cutoffs alone. BMI also has limitations for people with unusually high muscle mass, older adults, pregnant people, and some other populations or circumstances. A spreadsheet should label adult categories clearly if it includes them, and should not present those categories as suitable for everyone.

For the metric example, 170 cm and 70 kg gives about 24.22, which falls in the adult healthy-weight category under the commonly used ranges. That statement describes the category only; it does not establish whether the person is healthy. A healthcare professional can interpret BMI together with relevant history, examination, and other measures.

Add categories without overstating what they mean

A worksheet can show a text label beside a BMI value, but a category column should be limited to the population and reference standard it is intended for. For example, adult thresholds can be used for an adult-only tracker if the sheet prominently says so. Do not quietly extend those labels to children or use them to make a medical judgment.

If categories are included, document the exact boundaries and decide how to handle values at the thresholds. The common adult convention treats 18.5 as the lower edge of the healthy-weight category, 25 as the start of overweight, and 30 as the start of obesity. Rounding may make a displayed value appear to sit on a boundary even when the underlying value is slightly above or below it. For that reason, use the unrounded result for any category logic and show enough decimal places for a reader to understand the result.

Conditional formatting can make a worksheet easier to scan, but color should not be the only way categories are communicated. Add text labels, use accessible contrast, and include a note explaining the ranges. A colored cell is a visual aid, not a clinical assessment.

Privacy and responsible use

Height and weight can be sensitive personal information. If a workbook contains identifiable measurements, store it in an appropriate location, limit access to people who need it, and avoid sending it through channels that are not suitable for private information. A spreadsheet’s formulas do not provide medical confidentiality or automatically protect the file from access.

Use the sheet for calculation and record keeping, not as a substitute for professional advice. If a result is unexpected or raises a health concern, confirm the measurements and discuss the context with a qualified healthcare professional. People should not be encouraged to make major health decisions based only on a BMI value or a spreadsheet category.

Frequently Asked Questions

What is the Excel formula for BMI in kilograms and centimetres?
With height in centimetres in A2 and weight in kilograms in B2, enter =B2/(A2/100)^2 in C2. For example, 170 cm and 70 kg returns approximately 24.22.

What is the BMI formula for pounds and inches in Excel?
With height in inches in A2 and weight in pounds in B2, enter =703*B2/(A2^2) in C2. A value of 154 pounds at 68 inches returns approximately 23.41.

Can Excel calculate BMI for several people?
Yes. Put each person’s height and weight on the same row, enter the formula for the first record, and fill it down. Use clear unit labels and confirm that each copied formula points to the inputs on its own row.

Should BMI in Excel be rounded?
Usually, format the cell to display one or two decimal places rather than changing the underlying result. This keeps the calculation more precise while making the displayed value easier to read.

Can I use adult BMI categories for a child?
No. Standard adult cutoffs are not the appropriate interpretation for children and teenagers, whose BMI is assessed using age- and sex-specific growth references. Ask a healthcare professional to interpret a child’s result.

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.