Change % weighted totals

[AJMIlne]

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

[tamthat]

A1.value = 20%
B1.value = 20%
C1.value = 20%
D1.value = 20%
E1.value = 20%
You will change value in A1

Please Login or Register  to view this content.

Fill to right

[AJMIlne]

Hi,

Thank you very much for the quick response

How do I set it, so that all numbers can be changed B1,C1,D1,E1 and have the same effect?

Therefore, I could change D1 upwards and all change their %'s. (e.g a real time weighting effect)

[tamthat]

@@. I don't know
Pls get file here. Change value in A1

[Phuocam]

changed B1,C1,D1,E1 and have the same effect?

Try this in A2:

=IF(A1<>"",A1,(1-SUM($A$1:$E$1))/COUNTBLANK($A$1:$E$1))

Copy cross.

[AJMIlne]

Hi Phuocam,

thank you very much!

[Phuocam]

You're welcome!