View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
amh amh is offline
external usenet poster
 
Posts: 21
Default Always Sum a list of %'s to 100%

How do I always get a list of percentages to sum to 100%?

For example, the list below all sums to 100%. I want to develop a formula
so that if I change 6% to 7%, the rest of the numbers will change so that
they all equal 100% again. So basically, the 1% difference needs to be
redistrubted evenly to the other percentages automatically when I change the
6% to 7%. I want this formula to hold all the way through--if I want to
change the 59% to 30% and so on, I still want them to sum to 100%.

59.000%
15.000%
5.000%
2.000%
6.000%
4.000%
2.000%
5.000%
2.000%

Help is appreciated!