Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Mar 2004
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    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. #3
    New Lounger
    Join Date
    Mar 2004
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    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. #5
    New Lounger
    Join Date
    Mar 2004
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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
  •