How To Calculate BMI In Excel With Simple Formulas

Excel can calculate BMI for one row or a full list. The main task is setting the units correctly first, then using the right brackets and exponent operator. A small spreadsheet error can affect every row below it.

Use the BMI Calculator to check one row. This guide shows metric and pound-based formulas, how each cell works, and how to copy the formula safely.

How To Set Up A BMI Worksheet In Excel

Put one type of data in each column, and add the unit to each heading. Keep one person or one date on each row, which makes the sheet easy to check.

Metric Sheet Layout

Cell	Heading	Sample Value
A1	Name	Sample Adult
B1	Weight kg	72
C1	Height cm	175
D1	BMI	Formula

Type the sample data in row 2. Keep the unit out of the number cell: a cell with “72 kg” may be stored as text, while a cell with “72” can be used in a calculation.

For pounds, use one column for weight and one for total inches, or use separate feet and inches columns. Do not type 5 ft 10 in as 5.10. That decimal does not represent that height.

The Metric BMI Formula In Excel

Metric BMI uses kilograms and metres. When height is in centimetres, divide by 100 first, then square the result. Excel uses the ^ symbol for an exponent.

Metric Formula

=ROUND(B2/((C2/100)^2),1)

Formula Steps

1. C2/100 converts centimetres to metres.
2. ^2 squares the height.
3. B2/... divides weight by that value.
4. ROUND(...,1) displays one decimal place.

The Metric Excel Math In Full

Use B2 = 72 and C2 = 175. The first cell holds kilograms, and the second cell holds centimetres.

Calculation

• Height in metres = 175 / 100 = 1.75
• Height squared = 1.75 x 1.75 = 3.0625
• BMI = 72 / 3.0625
• BMI = 23.510204…
• ROUND(23.510204...,1) = 23.5
• Rounding rule: nearest tenth

Excel retains more decimal places internally than the cell displays. The ROUND function sets the final result: Microsoft describes the syntax as ROUND(number, num_digits), and a value of 1 for num_digits keeps one decimal place.

The Imperial BMI Formula In Excel

Imperial BMI uses pounds and inches. Multiply weight by 703, then divide by height in inches squared. Use brackets so Excel squares the full height correctly.

Formula With Total Inches

=ROUND((703*B2)/(C2^2),1)

Formula With Feet And Inches

=ROUND((703*B2)/(((C2*12)+D2)^2),1)

The inner brackets convert feet and inches to one combined value, and the outer brackets square that full value. Microsoft describes the order Excel follows for exponents, multiplication, and division; brackets make that order explicit.

The Imperial Excel Math In Full

Use a weight of 180 lb and a height of 5 ft 10 in. First convert the height to 70 in, then apply 703 in the formula.

Calculation

• Total inches = (5 x 12) + 10 = 70
• Height squared = 70 x 70 = 4,900
• Weighted value = 703 x 180 = 126,540
• BMI = 126,540 / 4,900
• BMI = 25.824489…
• ROUND(25.824489...,1) = 25.8
• Rounding rule: nearest tenth

The How To Calculate BMI guide explains both formulas outside Excel. Use that guide to check the base math; the spreadsheet should follow the same steps, since Excel only speeds up the work.

How To Copy And Verify BMI Formulas

Excel adjusts row references when you copy a formula down. A formula in D2 uses B2 and C2, and in the next row Excel adjusts those references to B3 and C3. This saves time on a long list.

1. Enter the correct formula in the first BMI cell.
2. Select that cell.
3. Drag the fill handle down.
4. Check a row near the top.
5. Check a row in the middle.
6. Check the last row.

Verify at least one row by hand or with the BMI Calculator. An incorrect first formula will be copied to every row, and a spot check helps catch that error. Keep the source columns visible while you review.

You can also add a note beside each heading, for example “height in cm” near the input column. A clear note can prevent a unit mix-up before the formula runs, which is easier than fixing a large sheet later.

What Excel Errors Change The BMI Result

Most errors come from units or brackets. Blank cells and text can also break the calculation. A result may look normal even when the input is incorrect, so check the formula and the row data together.

Problem	Result	Fix
Centimetres not converted to metres	BMI becomes far too small	Use C2/100
Height not squared	Formula is incorrect	Add ^2
Feet entered as 5.10	Height is wrong	Use feet and inches cells
Brackets are missing	Excel applies a different order	Group each step
A row is blank	An error may display	Use a blank-cell check
Unit text is in a cell	The cell may not be numeric	Put units in headings

A guarded metric formula can leave a blank result until both input cells have data:

=IF(OR(B2="",C2=""),"",ROUND(B2/((C2/100)^2),1))

This extra rule changes the display, not the BMI math. The rule does not verify whether a height or weight is realistic, so data checks should still be used. Review unusual values before relying on the sheet.

How To Read BMI From A Spreadsheet

Excel can perform the math, but Excel cannot assess health. The CDC calls BMI a screening tool, and BMI also does not distinguish fat, muscle, and bone. A clean spreadsheet does not remove those limits.

See Is A BMI Calculator Accurate for more on what the result means. The Health Calculators hub links BMI, BMR, and TDEE tools. Each result should be interpreted with care, and a health expert can add personal context.

Sources And Notes For BMI In Excel

• Microsoft Support, Use Calculation Operators In Excel Formulas
• Microsoft Support, ROUND Function
• CDC, About Body Mass Index
• CDC, Adult BMI Calculator

This guide provides general health education and Excel steps. A BMI result does not replace personal care from a qualified health professional.