CALCULATE YOUR IDEAL AND RECOMMENDED WEIGHT USING MICROSOFT EXCEL

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.

CALCULATE YOUR IDEAL AND RECOMMENDED WEIGHT USING MICROSOFT EXCEL

Watch the Video Tutorial


Microsoft Excel Tutorials, Microsoft Excel Video Tutorials, Calculate Your Ideal and Recommended Weight Using Microsoft Excel, Macros Usage, VB Scripts in Excel