ok, after an hour of trying I am asking for help- this is hopefully a problem other weight lifters have encountered:

So I am using Excel to record my sessions, and now, months later, I got the idea to calculate the volume but I don’t know how to make Excel actually calculate it.

This is an example row:

Date/Lat Pulldown/3x6x100

so 3 sets of 6 reps of 100 pounds so the volume would be 1800.

So 3x6x100 is in the wrong format for excel to calulate it.

I Find and replace x with * to make it 3*6*100

then I concatenate(“=”,cell) where cell is the cell containing 3*6*100

and I do indeed get =3*6*100

but I can’t get Excel to actually calculate the result. Manually I need to go in there and hit “enter” at the end of the line.

*arg* I really am curious to see what the volumes are but I can’t go through it manually- too much.

I tried changing the format of the cell, I tried copy, paste special values

I can’t get it to work.

thanks!

and please no one make fun of me for using Excel! Whatever it takes to lift weights, right? For me, I like to see my progression etc.