16
Help Me / Re: Formula Help
« on: January 22, 2008, 09:22:55 AM »
Just noticed the formula works on scores not points... if i change the word to points will it recognise it as all i get at the moment is Formula Error
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Average points doubled, must play 7 games or more to qualify, 0.5 points added every time you play
switch(r, 1, n,
2, if(n >= 4, n-2*r, 0),
3, if(n >= 6, n-2*r, 0),
4, if(n >= 8, n-2*r, 0),
5, if(n >= 10, n-2*r, 0),
6, if(n >= 12, n-2*r, 0),
7, if(n >= 14, n-2*r, 0),
8, if(n >= 16, n-2*r, 0),
9, if(n >= 18, n-2*r, 0),
10, if(n >= 20, n-2*r, 0))
switch(r, 1, n, 2, n - 2r, 3, if(n >= 6, n-2r, 0), 4, if(n >= 8, n-2r, 0), 5, if(n >= 10, n-2r, 0), 6, if(n >= 12, n-2r, 0), 7, if(n >= 14, n-2r, 0), 8, if(n >= 16, n-2r, 0), 9, if(n >= 18, n-2r, 0), 10, if(n >= 20, n-2r, 0))