Need an alternative to lots of nested IF statements

I originally posted this attachment in Change a cell in a range and all other cells in the range change to keep the sum at 100% I don't think that this post should be part of the original because they are completely different problems. Moderators please let me know otherwise.

While only one of the issues I was trying to accomplish at the time was addressed in the previous post, that of keeping the sum of a range of cells always equal to 100%, I ended up not using the suggestion and figured that part out on my own because I needed the percentages to be top heavy so the payout would get better the better a team placed.

The part I'm having a problem with now is dealing with the end of league place standings in the case of a tie between two or three teams and with the possibility of there being more than two teams for any given place and/or more than two teams tied for different placings. I started to figure it out (I thought) but realized that each placing down in the standings, 1st to 2nd to 3rd, etc., would require an increasingly longer nested IF statement to be made and it's unbelievably confusing. See the example below of just 1st through 4th.

1 1
2 IF(D22=D23,1,2)
3 IF(AND(D22>D23,D23>D24),3,IF(AND(D22>D23,D23=D24),2,IF(AND(D22=D23,D23=D24),1,2)))
4 IF(AND(D22>D23,D23>D24,D24>D25),4,IF(AND(D22=D23,D23>D24,D24>D25),3,IF(AND(D23>D24,D24=D25),3,IF(AND(D23=D24,D24=D25),2,IF(AND(D22=D23,D23=D24),2,3)))))

By the time I get to 24th place this statement will be about 10 miles long.

Open the attachment and start messing around with the "Total Games Won This Season" column (D22:D45) by changing the scores to and from ties. I gave up at 4th place as shown above. Is there an easier way to make it so the "Place (with ties)" column (B22:B45) will automatically change the place numbers to accommodate for teams being tied at the end for multiple places and the possibility of more than just two teams tied for any specific placing?

Let me know if you need more explanation.

Thanks!