1
Help Me / Formulae help
« on: March 05, 2013, 05:05:09 PM »
Hi, Im currently using the formula below to give 1st place 2 more points than 2nd and 2nd 2 more than 3rd down to 4th then the rest lose 1 point at a time. Can someone tell me what I need to change to have it that 1st place gets 4 points more than 2nd and 2d gets 3 points more than 3rd and 4th onwards gets 1 point less each time. Sorry if ive made this sound complicated but I want the top 3 places to be rewarded more for their efforts.
max(1, n - r + 1) + if(n <10, switch(r, 1,3, 2, 2, 3, 1), switch(r, 1, 8, 2, 6, 3, 4, 4, 2))
max(1, n - r + 1) + if(n <10, switch(r, 1,3, 2, 2, 3, 1), switch(r, 1, 8, 2, 6, 3, 4, 4, 2))