Sand_in_my_Boots
New Member
- Joined
- Oct 12, 2002
- Messages
- 2
I need some help figuring out what formula, would best suite my needs and how to make it meet several criteria’s: Age group, Repetitions, Gender for example if a 21 year old male soldier does 42 sit ups then his raw score for push up would be 60 percent, and a female same age, would score 100 percent.
Thus when I enter the age, M/F (gender), Repetitions the excel sheet will auto configure the Raw scores for each event, then if the soldier scores less than 60 percent
In any event it will enter a Fail for that soldier, and a pass if the soldier scores greater than 60 percent.
This message was edited by Sand_in_my_Boots on 2002-10-14 03:32
This message was edited by Sand_in_my_Boots on 2002-10-14 03:33
Thus when I enter the age, M/F (gender), Repetitions the excel sheet will auto configure the Raw scores for each event, then if the soldier scores less than 60 percent
In any event it will enter a Fail for that soldier, and a pass if the soldier scores greater than 60 percent.
This message was edited by Sand_in_my_Boots on 2002-10-14 03:32
This message was edited by Sand_in_my_Boots on 2002-10-14 03:33