Author Topic: Simple formula needed  (Read 863 times)

Mahound

  • Sr. Member
  • ****
  • Posts: 394
  • THE ONLY time i get screwed is when i play poker!
    • View Profile
Simple formula needed
« on: February 17, 2012, 12:31:47 PM »
The formula
n-r+1 gives each player one more point than the previous eliminated  player.

But how do I set this formula so that the score would only apply to the top 50 only.

For example: Players who finish 51st  and below would score no points/
So
1st would get 50
2nd would get 49
3rd would get 48
48th get 3 points
49th gets 2 points
50th gets 1 point

 I know thats its something to do with "max", but cant figure it out

Thanks in advance




TIMMER

  • Hero Member
  • *****
  • Posts: 555
    • View Profile
Re: Simple formula needed
« Reply #1 on: February 17, 2012, 01:41:57 PM »
Not 100% sure,      max(51 - r, 0)   

Mahound

  • Sr. Member
  • ****
  • Posts: 394
  • THE ONLY time i get screwed is when i play poker!
    • View Profile
Re: Simple formula needed
« Reply #2 on: February 17, 2012, 06:44:31 PM »
Worked a treat Timmer . Its for a team game and only the top 50 score points.

Thank you

TIMMER

  • Hero Member
  • *****
  • Posts: 555
    • View Profile
Re: Simple formula needed
« Reply #3 on: February 18, 2012, 01:33:49 AM »
Wasn't sure, I was on the wii,  had no way to test it,  :-\