Hi folks,
First post here, didn't know such a place existed. I'm trying to put together an excel document to be used as a workout sheet for athletes. Not sure if this is possible but I would like to something along these lines:

I would like to have a cell containing the following "Max-100", in the next 5-10 columns I would like to be able to have the cell perform a simple percentage calculation based on the previously shown "100", not sure how to tell excel to ignore everything in the cell but use the "100". I can do the simple "=a1*.10" etc to get the percentages, not sure how to tell the next cells to use only the "100". If I used the example of 100x.10, I would like for the answer to the calculation to show up in the next column that will also contain other characters like so "5/%/", trying to tell my students to do 5 reps/#pds/.

Is this possible?

Thank you in advance,
tlb27