BMI calculator

The calculation of BMI (Body Mass Index) is purposely meant to know if the person has normal, overweight, or obesity 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.

Display the weight (1) and height (2) of the person in kilogram and meter.

weight and height

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

divide wieght by height

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

normal weight

 

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

overweight

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

obesity

 

In conclusion, if it happens that the person is below 18.5, then such person is under weight, and the 80 is in kilogram, while 1.8 was in meter, which means the person is 180cm in height.

You can download free BMI Calculator template here