Site icon Best Excel Tutorial

How to Calculate Bmi in Excel

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.

What is BMI?

BMI equation is:

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

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

Or more specifically:

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.

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

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).

Click on another empty cell (E1) (1), and type in what is shown in 2 in the picture below.

Click on another empty cell (1), and type in number 2.

You can download free BMI Calculator template here

Exit mobile version