Results 1 to 3 of 3

Thread: If statements

  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    313
    Thanks
    0
    Thanked 0 Times in 0 Posts

    If statements

    I have a user who needs help with a file. She is calculating results of races. I will just paste exactly what she wrote to me. Under Race #1 column, when I put "1" in next to Racer #12 (that means racer #12 came in 1st), I want it to calculate a "7" in the Points column ('cuz that's how many points 1st place gets). When I put "2" in next to Racer #5 ('cuz #5 came in 2nd), I want it to calculate a "6" in the Points column ('cuz that's how many points 2nd place gets).1st place gets 7 points, 2nd-10th gets 6 points
    11th-19th gets 5 points, etc.
    Then at the end I'll sum up the columns and rows - but I want to just be able to go down the list and put in which place # (1st - 43rd) each player finished and I want it to calculate in the Points column how many points they earned for that finish.

    So what is the easiest way to accomplish this?

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: If statements

    Probably the best approach is to use a lookup table.

    Then the points could be allocated with the following :-

    Vlookup(position,Points,2)

    the lookup tabel should look something like :

    Position Points
    1 7
    2 6
    11 5
    20 4
    30 3
    40 2
    50 1

    I am attaching a sheet to show excatly what is involved. I named the Lookup table "Points". Hope it achieves what you are looking for.

    Andrew C
    Attached Files Attached Files

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    313
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: If statements

    Thank you so much for taking the time to help me. I will work on it after lunch and forward to the department in need. Thanks again!

Posting Permissions

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