Were doing a contest at my work (Curves) for the women…the objective of the contest is to have the highest weight loss percentage. I was wanting to do a spreadsheet to be able to keep up with all of the woman and their progress, but when I opened up my Excel i realized i’m not real sure how to have multiple women and their results in this. Please help!?!?!!?!?!
One Response
Leave a Comment
December 21st, 2009 at 11:17 pm
Try this
Column A is for names
Column B is for initial weight
Column C is for latest weight
Column D is for percentage change
A1 to D1 are cells for column headers
After list all the names of the participants from A2 downwards and their respective initial weight from B2 downwards, in D2 put this formula
=(C2-B2)/B2
Format D2 with using the percentage style button on the formatting toolbar
Copy D2 downward to match the filled cells on its left
Then whenever you have a latest weight entered in Column C, the percentage of the weight loss will be shown on Column D.