body mass index formula question?
i know the formula is (weight/heightxheight)x703= bmi, but the military uses neck and abdomen measurements in theirs...so what is that formula that included those? i found this http://www.armystudyguide.com/content/useful_files/apft_and_weight_control/body-fat-calculator-2.shtml but my excel won't properly instat the analysis tool pack so only half of it works.
Public Comments
- Hi thtanoyinguy, The only functions I see in that workbook that require the Analysis Tookpak are the MROUND functions in cells F11:F14 of the "Blank Female" sheet, which are being used to round to the nearest 0.25. You can replace them with these formulas, which return the same results but don't require the Analysis Toolpak: =ROUND(E11*4,0)/4 =ROUND(E12*4,0)/4 =ROUND(E13*4,0)/4 =ROUND(E14*4,0)/4 First, unprotect the "Blank Female" sheet (in Excel 2003, Tools | Protection | Unprotect Sheet). Then, replace the formulas in cells F11:F14 with the formulas I've provided above. If there are any other ATP functions in the workbok, they'll return a "#NAME!" error. Let me know if you find any. Good luck, Greg
