Golfers win money according to what position they finish in tournament. Prize money for each position predetermined. Is there a function, or a combination of functions, that will automatically calculate winnings for each player if there are ties? Example:

1st - $10,000:
2nd - $8000
3rd - $5000
4th - $2000
5th - $1000

Joe, Jim, and Jack finished tied for 2nd, so they split 2nd, 3rd, and 4th money equally. I know they would get $5000 each (average of 2nd,3rd, and 4th money), but is there a a formula I can plug in that will automatically calculate winnings for all ties? Some tournaments have 70 players cashing, and there are many ties for positions. I'm looking to find a way to automatically calculate each player's winnings without having to do the averaging for all the ties.