spot_img

BMI calculator in Excel

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 heightOn an empty cell, example C1, click on it (1), divide the weight by height, and add ^2 (2), and press enter.
divide wieght by heightClick 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.

Template

You can download the Template here – Download
Further reading: 
Basic concepts 
Getting started with Excel
Cell References
spot_img
Previous articleAvoid Errors Using IFERROR-Everyone Should Know
Next articleLinking Text Box To A Specific Cell

RELATED ARTICLESMORE FROM AUTHOR