1. ## 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. ## 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

3. ## 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
•