Calculate your ideal and recommended weights - Formulas In Excel - Microsoft Excel Tutorials

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

Convert from hours to minutes - Formulas In Excel - Microsoft Excel Tutorials

5.  Convert from hours to minutes

As a task, time in a timesheet has to be converted from hours to minutes.

To convert time to minutes:

1. In a worksheet, enter your own data or the data shown in Figure 1-5.
2. Select cells B4:B8.
3. Enter the following formula: =A4*24*60.
4. Press <-Ctrl+Enter->.

5. Format cells B4:B8 as general by selecting the Format menu and choosing Cells and General then clicking OK.

Note: To convert minutes to hours and minutes format, use the formula =A4/24/60. Remember to format the cells with a time format, as shown in cell C4 in Figure 1-5.

Watch the Video Tutorial - https://www.youtube.com/watch?v=HajulaXpweU

 

Hope You Like This Tutorial - Give Comments