Score based on time range HELP!

[basizeland]

I help run a high school program where the students have to race miniature cars and we have a excel spreadsheet to record all the times and then generate the scores for the different categories of racing.

We have change the way we calculate the fastest reaction time points in that we know specify the points they will receive if they get under a certain time.

For Example.

20 points for a time less than 0.140
17 points for a time less than 0.150
15 points for a time less than 0.160
13 points for a time less than 0.170

I am having trouble trying to work out the formula to allocate the points to each student.

I have a column with everyones reaction time in it and i need to reference those against the range to work out how many points they have got.

Any help would be great even if you can point me in the right direction.

[Fletch74]

Hi,

Assuming you have your Data in Cell B1, you could try this formula;

Please Login or Register  to view this content.

[kvsrinivasamurthy]

If B1 contains Time,
=IF(B1>0,IF(B1<0.14,20,IF(B1<0.15,17,IF(B1<0.16,15,IF(B1<0.17,13,"")))),"")