Change a cell in a range and all other cells in the range change to keep the sum at 100%

This pertains to a league team payout structure.

There can be up to 24 teams. The teams place from 1st through 24th in the final standings. Each team gets a percentage of the overall league payout based on their final place in the standings. I want the last place team (no matter how many teams are in the league for a given season) to automatically populate the correlating % cell (D30 in the example) with a percentage that makes the team payout for last place always be $180.00 and make all other team's (above last place) pay out percentage change automatically with a sliding scale that is weighted slightly heavier towards the top.

I've attached an example of what I'm doing. In the example there are 9 teams of a possible 24.

Basically, I'd like to be able to change any of the cells in Range (D22:D45) to any number from 1 to 100 and have all of the other cells in the range automatically recalculate themselves and changing their values so the SUM of the range is always 100%. There needs to also be a way to deal with teams that have a tie in number of games won....

I appreciate any help you can provide. Thanks!

I hate to complain but, what do I have to do to get some help on this? I understand I only posted this yesterday but 109 people looked at it and not even one suggestion, comment or otherwise was made. Is there something wrong with the way I posted? Did I not follow good protocol somehow?

How about
=C22/SUM($C$22:$C$45)
Drag the formula down.
The total should always = 100%

Sorry for my impatience.... Been working on this project for a very long time and just haven't needed a lot of help until now.

Hi Dave. Thanks very much for your help. Your formula does keep the total at 100% and changes all of the percentages for the rest of the cells in the range. Is there any way that you can think of to make the weight be heavier at the top and lighter at the bottom?

I could modify your formula such as =(C22+(C22*0.25))/SUM($C$22:$C$45) for each percentage cell but that would put me right back to where I started with having to manually adjust it each season due to the number of teams.

I am not sure what you mean.
Percentage is percentage, the largest value has the largest percentage.

What I mean is so the percentages are more spread out. Right now its very evenly spread out. The last place team is making too much and the first place team isn't making anywhere near enough.

For instance, the percentages I'm manually entering right now to make the spread more pronounced for the 9 teams is:

23.0%
17.0%
13.0%
11.0%
10.0%
8.0%
7.0%
6.0%
4.5%