7
« on: June 22, 2006, 04:04:17 AM »
I have substituted the equation with the answers as this seems easier so now all i want to do now is add 2% per player over 10 entered to the total
I tried this formula but not to sure why it gives the wrong answer 1t should be 14 players coming first should be 1944
1800*1.08 or 8%
if(r == 1,1800, if(r == 2, 1440, if(r == 3, 1230, if(r == 4, 1050, if(r == 5, 900, if(r == 6, 750, if(r == 7, 600, if(r == 8, 450, if(r == 9, 300, if(r> == 10, 150, 0))))))))))+if(n > 10, (n-10)*.02, 0)
Thanks
1st, 1,800.08
2nd, 1,440.08
3rd, 1,230.08
4th, 1,050.08
5th, 900.08
6th, 750.08
7th, 600.08
8th, 450.08
9th, 300.08
10th, 150.08
11th, 150.08
12th, 150.08
13th, 150.08
14th, 150.08