Forum Discussion
need help to creating formula in excel
Im new to figuring out how to insert a formula in excel. Can anyone help me figure how to do this formula into the cells and to keep there?
Formula would be:
Body fat percentage (%) = (27 x sum of skinfolds sites) divided by body weight (lbs)
There would be 9 skinfold sites i would be using.
Thank you so very much!
2 Replies
Apparently, "percentage body fat" is a decimal representation, not an actual percentage. For example, 13 to represent 13% or 0.13.
Example:
Formulas in A2 (read: "12.90 percent"):
=27 * SUM(C2:K2) / B2
- Attach a sample file with demo data and your desired output. Then explain logic to gain that output from your input data.
