posting points relating to rank

N

Not too bright

I am trying to allocate points related to finishing position.
I have used "RANK" to determine finishing position.
Example:
IF D1=1 then D2=25
IF D1=2 then D2=20
IF D1=3 then D2=17
IF D1=4 then D2=15
etc. down to position 20 approx
 
T

T. Valko

You need to provide the details on the entire point distribution. Also, how
should ties (if possible) be handled?

Typically, ties split the pool. For example...

1st place = 100 pts
2nd place = 75 pts

If there are 2 tied for 1st place they each recieve 100+75/2 = 87.5 pts
 
N

Not too bright

Thanks TV

The points distribution is:-
1st - 25 points
2nd - 20
3rd - 17
4th - 15
5th - 14
6th - 13
5th - 12
6th - 11
7th - 10
8th - 9
9th - 8
10th - 7
11th - 6
12th - 5
13th - 4
14th - 3
15th - 2
16th - 1
17th - 1
18th - 1
19th - 1
20th - 1
All additional placings = 1

Full points will be allocated to ties i.e. 3 of 1st places all receive 25
points
Of coarse the next placed person will be 4th with the allocation of 15 point

The "RANK" function sorts the places out satisfactorily, I just need to
address each rank cell with the correct points - Thanks again
 
T

T. Valko

Ok, create a 2 column table with the place in the left column and the
corresponding pts in the right column:

...........G..........H
1........1..........25
2........2..........20
3........3..........17
4........4..........15
..........................
20.....20..........1

Assume rank is in A1.

=VLOOKUP(A1,$G$1:$H$20,2)

Copy down as needed.
 
Top