R
race39
I am trying to generate the points earned in an event, as follows:
The first table (START) shows the starting order(with entrant #38 being used
as example)
START
1st 2nd
3rd 4th
5th 6th
7th #38
9th 10th
11th 12th
The second table (FINISH) show the results.
The third table (FINISH POSITION) sorts the finish order sorted into a column
FINSH FINISH POINTS
POSITION
38 48 1 38 32
58 98 2 48
22 26 3 58
23 03 4 98
07 24 5 22
27 28 6 26
7 23
8 03
9 07
10 24
11 27
12 28
The winner gets 18 pts
Second place gets 18-2=16pts
Third gets 18-2-2=14pts
etc.
In additon passings points are awarded
2 points for each position gained from starting positon.
eg.
#38 is awarded 18pts for the win
#38 started in the 8th position and is awarded 14pts for passing
#38 total pts is 32, as shown in 4th table (POINTS)
This total was generated using the IF function, which is limited to 7
conditions, therefore I cannot use it with a table of 12 entrants.
Can you suggest a complete solution?
I will need an example.
TX
The first table (START) shows the starting order(with entrant #38 being used
as example)
START
1st 2nd
3rd 4th
5th 6th
7th #38
9th 10th
11th 12th
The second table (FINISH) show the results.
The third table (FINISH POSITION) sorts the finish order sorted into a column
FINSH FINISH POINTS
POSITION
38 48 1 38 32
58 98 2 48
22 26 3 58
23 03 4 98
07 24 5 22
27 28 6 26
7 23
8 03
9 07
10 24
11 27
12 28
The winner gets 18 pts
Second place gets 18-2=16pts
Third gets 18-2-2=14pts
etc.
In additon passings points are awarded
2 points for each position gained from starting positon.
eg.
#38 is awarded 18pts for the win
#38 started in the 8th position and is awarded 14pts for passing
#38 total pts is 32, as shown in 4th table (POINTS)
This total was generated using the IF function, which is limited to 7
conditions, therefore I cannot use it with a table of 12 entrants.
Can you suggest a complete solution?
I will need an example.
TX