Hello everyone, I'm a real beginner when it comes to Excel and thus I'm new to this forum. I've been having some trouble trying to create an excel sheet for my training program and hopefully you can help me out.

So far I have made cells in which I'm typing in my "One repetition maximum" (the weight I can lift once with 100% effort) in any given lift and the cells listing the weeks and days of my training as well as the repetitions that I'll be doing each of those days. But with the certain repetition ranges I need certain percentages of my "One rep max" in order to complete the required number of reps.

I'll give an example:
One cell reads "Bench press max" and another is where I type in my one rep max in the bench press, for instance, 100, as in 100 kg. Then the next sheet will have the formulas needed to calculate 70%, 80% and 90% of my one rep max (=round(sheet1!A3*0,7;0) and so on). Those are the numbers I'll lift on different training days.

What I need is to be able to have a drop down list of different variations of the bench press and have the cells show different percentages of my one rep max for every variation that I choose.

Example:
Drop down list:
Paused bench press
Close grip bench press
Incline bench press

So for each of those exercises I want different percentages of my one rep max to be calculated (if I choose paused bench press I want 80% of my bench press max calculated, Close grip bench press 70% etc).

How would I go about doing so? I want certain numbers to be calculated from my one rep max bench press depending on what variation I choose in the drop down list.


It's hard to explain exactly what I'm trying to accomplish without writing a novel since my training regimen is very meticulously thought out and specific. I apologize if it was a hard read and I'm thankful for any answers!