To make a spreadsheet similar to the one in Example 2, use the steps below.

1. Enter the title "Factor" into cell C1.
2. In column A starting with cell A2, enter the titles "Weight," "Wrist," "Waist," "Hips," and "Forearm."
3. Enter 145 into cell B2, 6.5 into cell B3, 28 into cell B4, 36 into cell B5, and 10 into cell B6.
4. Enter the formula =(B2*0.732)+8.987 into cell C2.
5. Enter the formula =B3/3.140 into cell C3.
6. Enter the formula =B4*0.157 into cell C4.
7. Enter the formula =B5*0.249 into cell C5.
8. Enter the formula =B6*0.434 into cell C6.
9. In column A starting with cell A8, enter the titles "Lean body mass," "Body fat weight," and "Body fat percentage."
10. Enter the formula =C2+C3-C4-C5+C6 into cell C8.
11. Enter the formula =B2-C8 into cell C9.
12. Enter the formula =C9/B2 into cell C10.

To format the cells, use the steps below.

1. Select cells C2 through C9.
2. From the Format menu, choose Cells....
3. In the Format Cells dialog, select the Number tab.
4. From the Category: list, select Number.
5. For Decimal places:, enter 2. Then click OK.
6. Select cell C10.
7. From the Format menu, choose Cells....
8. In the Format Cells dialog, select the Number tab.
9. From the Category: list, select Percentage.
10. For Decimal places:, enter 1. Then click OK.

If you've calculated your body fat percent, you may be wondering what the healthy ranges are. To find out how your body fat percent compares, or to view the various body fat ranges, visit Body Spex.

Body Mass Index of Woman:

In the formula for body mass index, substitute the body fat percentage that you calculated in Example 2 for BF, the woman's age for age, and 0 for gender because she is female.

The woman has a body mass index of about 21.0.

Body Mass Index of Man:

Part 1: Calculate Body Fat Percentage

First, calculate the man's body fat percentage.

The man's body fat percentage is about 18.0%.

Part 2: Calculate Body Mass Index

In the formula for body mass index, substitute the man's body fat percentage for BF, the man's age for age, and 1 for gender because he is male.

The man has a body mass index of about 23.5.