need help to creating formula in excel

Copper Contributor

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
Attach a sample file with demo data and your desired output. Then explain logic to gain that output from your input data.

@roe0926 

 

JoeUser_0-1660446054035.png

 

Apparently, "percentage body fat" is a decimal representation, not an actual percentage.  For example, 13 to represent 13% or 0.13.

 

Example:

 

JoeUser_1-1660446158400.png

Formulas in A2 (read: "12.90 percent"):

=27 * SUM(C2:K2) / B2