How to calculate ideal body weight in Excel 2007. With using microsoft excel we can calculate an ideal body weight which refers to the formula for calculating ideal body weight according to Body Mass Index. Body Mass Index (BMI) is an ideal weight calculation is based on the formula:
BMI (BMI) = Weight (kg) / (height (m) x Height (m)
If the index has been obtained from the above calculation, the next step is to match your weight criteria of BMI according to the version of the WHO (World Health Organisation):
a.BMI <18.5 means Underweight
b. BMI 18.5 - 24.9 means you ideal weight
c. BMI 25 - 29.9 means over weight
d. BMI >= 30 means obese
To calculate your ideal weight in excel do the following:
Create a table as below