Hi,

If I have a list of %'s
e.g.

20%, 20%, 20%, 20%, 20%

Obviously = 100%

I want to be able to change a single % value e.g the first 20% to 10% and have the remaining 4 numbers all change in equal weighting (so the final total always is 100%).

Therefore the list would read

10%, 22.5%, 22.5%, 22.5%, 22.5%

How do I do this?? Is there a formula to use?

Thank you