# Thread: Relay Score Worksheet (Excel 2000 (9.0.2720))

1. ## Relay Score Worksheet (Excel 2000 (9.0.2720))

Hello everyone, I am new to excel and I am trying to figure out a formula. I am trying to rate runners based on their 40 times into 6 categories. 40-49 up to 90-99. I want to be able to enter their score into an excel cell, and have the one next to it tell me the corresponding Relay score. I really have no idea how to do this and i was hoping someone could help me out.

2. ## Re: Relay Score Worksheet (Excel 2000 (9.0.2720))

Not exactly sure what you want. Could use a VLOOKUP, but if you want to take a number from 40-99 and get the "category" 40-49, etc to 90-99, this is an easier formula (I assumed the score was in A1

=INT(A1/10)&"0-"&INT(A1/10)&"9"

Steve

3. ## Re: Relay Score Worksheet (Excel 2000 (9.0.2720))

Thanks for the quick response, let me try and describe it better.
lets say that in A1 i have the category 40 Time, i want to be able to put the time the person runs in A2, and then in in B2 have it spit out the range, 90-99, 80-89 . . .
so if the 90-99 range is a 40 Time of 4.24-4.36 and value of A1 is a 4.31, i want 90-99 to show up in B2. So the formula i'm trying to find is i think an IF formula with a corresponding relay time range equaling a rating range. I think it needs to be one big string formula with each set of parameters for each score. I just don't know how to write it out and string it together.

4. ## Re: Relay Score Worksheet (Excel 2000 (9.0.2720))

You could go with the VLOOKUP.
Put the min scores and ranges in a table (I just threw in some scores):
<table border=1><td></td><td align=center>C</td><td align=center>D</td><td align=center valign=bottom>1</td><td align=right valign=bottom>1.24</td><td valign=bottom>40-49</td><td align=center valign=bottom>2</td><td align=right valign=bottom>2.24</td><td valign=bottom>50-59</td><td align=center valign=bottom>3</td><td align=right valign=bottom>3.24</td><td valign=bottom>60-69</td><td align=center valign=bottom>4</td><td align=right valign=bottom>4</td><td valign=bottom>70-79</td><td align=center valign=bottom>5</td><td align=right valign=bottom>4.1</td><td valign=bottom>80-89</td><td align=center valign=bottom>6</td><td align=right valign=bottom>4.24</td><td valign=bottom>90-99</td></table>

Then if A2 has the score the formula in B2
<pre> =VLOOKUP(A2,\$C\$1:\$D\$6,2)</pre>

will lookup the range.

Steve

5. ## Re: Relay Score Worksheet (Excel 2000 (9.0.2720))

Ok, I'm a little sketchy on the VLOOKUP command. where would the table need to be, in the same sheet or another one? And would I need to have all the possible values 4.24-5.10 in the one column and the ranges in the othnevermind, i figured it out [img]/forums/images/smilies/smile.gif[/img] thanks for the help!

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•