How to Calculate Bmi in Excel

26Jul

The calculation of BMI (Body Mass Index) is purposely meant to know if the person has a normal, overweight, or obese weight. This is possibly done by certain components that make the BMI calculation a possibility. We will create the calculator together, and even calculate it.

Table of Contents

What is BMI?

BMI equation is:

BMI = weight (kg) / height (m)²

or easier:

BMI = kg/m2

In this formula, the weight is the weight of the person in kilograms, and the height is the height of the person in meters. The resulting value is the BMI.

The BMI test is one of the basic methods used by nutritionists, doctors and personal trainers to assess the body shape in terms of weight.

Simplified / Basic Classification of BMI Results

<18.5 – underweight
18.5–24.99 – correct value, i.e. normal
≥ 25.0 – overweight

Or more specifically:

<16.0 – starvation
16.0–16.99 – emaciation
17.0–18.49 – underweight
18.5–24.99 – correct value
25.0–29.99 – overweight
30.0–34.99 – 1st degree of obesity
35.0-39.99 – II degree of obesity (clinical obesity)
≥ 40.0 – III degree of obesity (extreme obesity); exceeding this threshold is also called morbid obesity, which is a serious threat to health

These ranges are based on research that has shown a correlation between BMI and the risk of health problems such as heart disease, high blood pressure, and diabetes.

Data preparation

Display the weight (1) and height (2) of the person in kilograms and meters.

weight and height

For example, in cell C1, click on it (1), divide the weight by height, and add ^2 (2), and press enter.

divide wieght by height

BMI Calculator

To categorize the BMI values into these ranges in Excel, you can use the IF function. The IF function allows you to specify a set of conditions, and then return a different value depending on which condition is met. In the case of BMI, you can use the IF function to return a text value such as “Underweight”, “Normal weight”, “Overweight”, or “Obese”, depending on the BMI value calculated.

Use if function to calculate a bmi in Excel.

Click on another empty cell (D1) (1), and type =IF(AND(C1>=18.5,C1<=25),”Normal”) (2).

normal weight