Poker League Percentages

[Savingprivatecp]

Hello,

Im new to the forum and a novice to excel.
Using other topics on this forum, i have managed to get a basic league put together but im unable to find anything along the lines of players winning a certain percentage of the overall points.
Example.
Each player is worth 200 points. So if, 8 people are playing thats 8x200 = 1600 points.
1st place takes 30% of the 1600 = 480 points
2nd place takes 20% of the 1600 = 320
3rd 13%
4th 10%
5th 9%
6th 7%
7th 6%
8th 5%
any other player below 8th, is worth just 50points.

What i need is, depending on the poisition of the player, for it to work out the points awarded and for it to be input in the league table.

Taken from another league table on this forum, find attached the layout.

Any help with this would be much appreciated.

Thanks

Craig