It doesn't award points automatically, per se. You can use log functions if you want some separation, or multiply it if you want more. If you want a basic formula, you can use the n-r+1, which would award points based upon total players and their finishing rank. (ie 4 players gives 4 for 1st, 3 for second, where as in a 40 player tournament, 1st gets 40, 2nd gets 39...). It's mainly how you want to award points. You could even use a switch function to award points that wont change for players, based upon their rank. For example, switch(r, 1, 20, 2, 15, 3, 10, 4, 5) tells the program to look at the player's rank (r), and find their place. If 5th or worse, they don't get points. If 1st, they get 20 (1, 20). If 2nd, then 15 in that example.
Again, it's mainly a question of if you want a lot of space, or little, or how volatile you want to shake things up each week.