Hello. I wonder if someone would be kind enough to create a formula for me?
The finishing position in a race will be entered in cell A2
Depending on the position, points will be awarded in B2
In C2 the points won in B2 will be multiplied by 20000
These are the positions and points awarded.
1st - 25 points
2nd - 18 points
3rd - 15 points
4th - 12 points
5th - 10 points
6th - 8 point
7th - 6 points
8th - 4 points
9th - 2 points
10th - 1 point
Thank You
Bookmarks