I'm seeking assistance with an Excel formula to calculate the Total Gym weight based on my bodyweight and added weight. Here are the relevant columns in my spreadsheet:
1. Degree of Incline
2. My Bodyweight
3. Added Weight
4. Calculated Total Gym Weight to be Applied
5. Total Weight
The challenge lies in the Total Gym's default body weights (e.g., 180, 200, 250, 300). My current weight is 219, which falls between the default increments of 200 and 250. I need a formula that accurately calculates the Total Gym weight for my specific bodyweight.
These formula's did not work
C2 * 32.174 * COS(RADIANS(A2))
C2*COS(RADIANS(A2))
Attached is my spreadsheet
Any guidance or direction would be greatly appreciated. Thank you
Bookmarks