I am trying to make a cell that would calculate the pass/fail averages for an Army Physical Fitness Test and am some what lost. I am going to attach the spread sheet I am working with in Excel 2007. If any on could help me out I would appreciate it. Some general knowledge for the sheet I am working with is the individual scores for each even (Push ups, Situps and 2 mile run) much be 60 points or greater to be a pass and automatically make the PT test a fail. These scores are already marked in red for easy id. I am hoping there is a way to make the percentage automatically adjust when I fill in the scores. If anyone could help I would apreciate it very much.
Bookmarks