16
Help Me / help with my points please
« on: January 12, 2007, 08:13:29 PM »
thanks for reading,
i have this so far, (n*3)-(r*3-3)
yes, 3 points per rank on #of players,
but woud like to have any rank 11th and on to the same point and just 2 points lower than 10th.
ex 11 players
1st 33 2nd 30.....9th 9, 10th 6, 11th 4
and 15 players
1st 45, 2nd 42......9th 21, 10th 18, 11th 16....15th 16.
i added the if(r=>10,n*30-32,0)
but it didnt work. says formula error, and as i type this now, i can see why.
please help
thanks
sharky
i have this so far, (n*3)-(r*3-3)
yes, 3 points per rank on #of players,
but woud like to have any rank 11th and on to the same point and just 2 points lower than 10th.
ex 11 players
1st 33 2nd 30.....9th 9, 10th 6, 11th 4
and 15 players
1st 45, 2nd 42......9th 21, 10th 18, 11th 16....15th 16.
i added the if(r=>10,n*30-32,0)
but it didnt work. says formula error, and as i type this now, i can see why.
please help
thanks
sharky