Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to calculate BMI in Excel and Google Sheets
Excel & Google Sheets
=A2/(B2^2)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Weight_kg | Height_m | BMI |
| 70 | 1.75 | |
| 85 | 1.80 | |
| 60 | 1.65 |
=A2/(B2^2)→22.8571428571
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Enter weight in kilograms in column A (header: Weight_kg) and height in meters in column B (header: Height_m).
- 2In column C, type the formula =A2/(B2^2) to get the BMI value — format the cell to 1 decimal place.
- 3In column D, add a category label: =IF(C2<18.5,"Underweight",IF(C2<25,"Normal",IF(C2<30,"Overweight","Obese"))).
- 4If your data uses pounds and inches, convert first: weight_kg = pounds * 0.453592, height_m = inches * 0.0254.
Tips
- Use named ranges (e.g., 'weight_kg' and 'height_m') to make the formula =weight_kg/(height_m^2) self-documenting for health or fitness trackers.
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
How do I calculate BMI with pounds and inches?
Use the imperial formula: BMI = (weight_lb * 703) / (height_in^2). In a cell: =(A2*703)/(B2^2) where A2 is pounds and B2 is total inches.
What BMI range is considered healthy?
A BMI of 18.5–24.9 is generally considered normal or healthy weight according to standard guidelines.