I want to make a formula that if a kid runs a certain time that it give it a point value as follows
4.4 or less 100
4.6-4.4 80
4.8-4.61 60
5.0-4.81 40
5.2-5.01 20
5.4-5.21 10
I want to make a formula that if a kid runs a certain time that it give it a point value as follows
4.4 or less 100
4.6-4.4 80
4.8-4.61 60
5.0-4.81 40
5.2-5.01 20
5.4-5.21 10
Create a lookup table...
http://www.contextures.com/xlFunctions02.html
HTH
Regards, Jeff
Tried that but i dont know what it put where
ex
a3 is his time of 4.56
and i want it to look at the table i have to put a point value in a4
a5 a6
4.4 or less 100
4.6-4.4 80
4.8-4.61 60
5.0-4.81 40
5.2-5.01 20
5.4-5.21 10
Let's start with this example and go from there...
Thanks that worked great
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks