Forum Discussion
Excel weightlifting math
I am trying to make a sheet for knowing how to breakdown my weight into the plates (45, 25, 10, etc) for example; 155 LB 45. 25. 10. 5. 2.5. 2. 2. ...
An interesting problem. I'm surprised nobody else has responded.
My solution probably isn't the most elegant, but it was fun playing around with it. I've even added a secret cell that will appear if you enter a number that doesn't work.
There actually are two formulas here. It probably would be possible (in fact, I'm quite sure it would be) to make it only one formula, but I thought it would be fun to have the intervening step visible. I did make that intervening step visible in only faint numbers, so it looks like this, set for 155 lb
And here it is for 170
Have fun!