POker league points system

Hello guys,
Great site.

I am writing a poker league table in excel.

I want to represent finishing places as points and have them alter event by event depending on how many peeps are playing.
I found this formula which does the job perfectly but I can't make it work in excel

2x(n-p+1) Where n=number of players; p=position

10 players gives 1st place 2x(10-1+1)=20 pts where as
4 players gives 1st place 2x(4-1+1)=8 pts

As well as the points I want to display total prize money won etc (which is easliy done by a noob like me) the problem I have is making the cells work out the points when I input the total players into one cell.

Halp

Hi,

Not quite sure if this is what you'r after, but assuming the total no. of players is in A1 and the position is in B1, then

Please Login or Register  to view this content.

Rgds

Hi,

Can you upload the workbook and indicate what results you want in a sample of the cells.

Rgds

Hi,

2x(n-p+1) Where n=number of players; p=position


And for third place does that imply a score for 10 players would be
2*(10-3+1)=16

Rgds

Hi,

See the revised file

I've added a total score table to the right of the positions on the events sheet. Just copy the formulae in Q6:AD6 down as necessary.

HTH

Here is the latest revision with a few tweaks here and there.

I am going to try and make some sort of table for cash prizes later.
Thanks Again

EDIT: The file below is not the correct one forgot i saved Richard's version to my desktop :D. See the post after this for rev2.