G
Guest
I'm currently creating a Physical Fitness Test roster for my work. I'm making
it to where as you fill in the information, it automatically puts the point
values into the corresponding cell.
I have three categories: Pullups, Crunches, 3-Mile Run. I have the Pullups
and the Crunches completed. Those were no problem. Simple calculations.
However, with the 3 mile run, I am having trouble finding the correct
function for what I need. The times will range from under 18:00 to 33:00.
18:00 and under run time will result in 100 points, whereas 33:00 run time
will result in 10 points, and over 33:00 will result in 0. The full list can
be found at http://usmilitary.about.com/od/marines/l/blfitmale.htm .
What I want is when I type the time into cell A1, cell A2 will automatically
display the correct amount of points for the run.
Thank you.
it to where as you fill in the information, it automatically puts the point
values into the corresponding cell.
I have three categories: Pullups, Crunches, 3-Mile Run. I have the Pullups
and the Crunches completed. Those were no problem. Simple calculations.
However, with the 3 mile run, I am having trouble finding the correct
function for what I need. The times will range from under 18:00 to 33:00.
18:00 and under run time will result in 100 points, whereas 33:00 run time
will result in 10 points, and over 33:00 will result in 0. The full list can
be found at http://usmilitary.about.com/od/marines/l/blfitmale.htm .
What I want is when I type the time into cell A1, cell A2 will automatically
display the correct amount of points for the run.
Thank you.