Cheers, is there a way of adding the 30 bonus points to all players score? for example
if(r < 9, switch(r, 1, .3, 2, .2, 3, .13, 4, .1, 5, .09, 6, .07, 7, .06, 8, .05) * 200 + 30 * n, 50)
Stu
Edit
I've got it functioning correctly awarding 1,200 points to 1st for a 10 player tourney using:
if (r < 9, switch(r, 1, .3, 2, .2, 3, .13, 4, .1, 5, .09, 6, .07, 7, .06, 8, .05) * 2000 * n, 80)
Note the 80 change for 9th+ (adding the bonus 30 points to 9th and above. I don't know if it is possible to award the bonus 30 points to 1-8th places.
NExt problem I have identified is I can't seem to get the prizes to appear on the prizes tab or on the display?
I have points for playing set to 200 and the above formula, when I use test range all the points are correct based on the percentile used.
Stu