Formulas for calculating ideal body weight first came into existence in 1871 when a French surgeon, Dr. P.P. Broca, created this formula (known as Broca’s index):
Weight (in kg) should equal height (in cm) – 100,
plus or minus 15% for women or 10% for men
In recent years, the body mass index (BMI) has become the standard for calculating ideal weight.
To determine ideal and recommended weights:
1. In a worksheet, enter your own data or the data shown in Figure 1-7.
2. Select cell B6 and type the following formula to determine your ideal weight (BMI=body mass index): =(B4-100)*0.9.
3. Select cell B7 and type the following formula to calculate your recommended weight: =B4-100.
4. Calculate the total difference in cells D6 and D7 by simple subtraction.
5. Calculate the difference in percentage in cells E6 (=1-B5/B6) and E7 (=1-B5/B7).
6. From the Format menu, select Cells.
7. Select the Number tab and then select Percentage from the Category list.
8. Set Decimal places to 2 and click OK.
Watch the Video Tutorial - https://www.youtube.com/watch?v=6GdF2wGKyKI
Hope You Like This Tutorial - Give Comments
