PDA

View Full Version : Moving Percentages


chrissbrady
Feb 2, 2009, 02:13 PM
I am having the problem of keeping my percentages adding up to 100%. If I have 10 columns with 10% a piece, the sum is 100%. If I then change the first column to 1%, is there any way for the rest of the columns to be automatically updated to 11% a piece?

e.g..

10 10 10 10 10 10 10 10 10 10 =total (100)

change the first column to 1%

1 11 11 11 11 11 11 11 11 11 =total (100)

and the rest of the columns automatically update to 11%, equally redistributing the 9% from the first column.

Thanks

JBeaucaire
Feb 2, 2009, 05:57 PM
That's not the way to do it. Percentages inherently are in an "add up to 100%" scenario. SO what needs to happen is that whatever is causing the values in those 10 cells to appear automatically updates for the other values as well.

If you MANUALLY change one of these 10 cells, you take it out of the array, so this wouldn't be the approach to use.

Post of the logic or formulas that is going into putting these values together. Or post a sample of your workbook so we can work with you directly.