The Problem
In this guide, we will explore exactly how to calculate the Body Mass Index (BMI) in Excel. The challenge is not just about getting one number. It is about doing the same calculation correctly across a full list of people.
When weight and height are stored separately, BMI has to be calculated with the right order of operations. That is where mistakes happen. A small formula error can change the result enough to place someone in the wrong category.
In this challenge, you need to calculate the BMI for each participant, then turn that number into a status such as Healthy or Overweight. After that, the summary section checks how many records were processed and how many people landed in the healthy range.
How We Solve It
The BMI formula is weight divided by height squared. In Excel, that means we either use the exponent operator ^ or the POWER function to square the height before dividing.
Once the BMI is calculated, IFS can assign a readable label based on threshold ranges. That makes the sheet much easier to review than a plain list of decimal results.
Method 1: Use the Exponent Operator
Method 1: Use the exponent operator to square height before dividing weight by it.
This is the shortest version of the BMI formula. Height is squared with ^2, then weight is divided by that result.
The key detail is the parentheses. They make sure the squaring happens in the denominator before the division uses the result.
=B2/(C2^2)
Method 2: Use POWER for Readability
Method 2: Use POWER when you want the same math written more explicitly.
POWER does the same math as ^, but some people prefer it because the intent is easier to read at a glance.
That can help when the workbook is shared with someone who understands functions more quickly than operators.
=B2/POWER(C2,2)
Method 3: Convert BMI to a Category
Method 3: Turn the BMI score into a readable category with IFS.
Raw BMI values are useful, but the category is easier to scan. IFS lets you test the BMI against multiple ranges in order and return the right label.
This makes the sheet easier to review quickly, especially when the goal is to count how many people fall into a specific range.
=IFS(D2<18.5,"Underweight",D2<25,"Healthy",D2<30,"Overweight",TRUE,"Obese")
Function Explanation
1. Division and Exponentiation
The main calculation is weight divided by height squared. That means Excel needs both division and exponent logic in the same formula.
The important part is the structure, not just the symbols. If the denominator is written incorrectly, the BMI result will also be wrong.
2. POWER
POWER raises a number to a chosen exponent. In this challenge, it is simply another way to square height.
It is useful when you want the formula to read more like a named step instead of a math operator.
Learn more this functionPOWER
3. IFS
IFS tests several conditions in order and returns the first matching result. That makes it a good fit for category bands like BMI ranges.
Instead of writing nested IF formulas, you can read the ranges from top to bottom and see the category logic more clearly.
Learn more this functionIFS
If you ever get strange BMI results, check the height unit first. The challenge uses meters, so the formula assumes the values in column C are already in meters.
Calculate the BMI for each participant using weight and height, then classify the result with a health status label. After the row formulas are done, finish the summary section so the worksheet shows how many total records were processed and how many people fall into the healthy range.