LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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!



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dropdown List - list item endings not visible if column too narrow AK9955 Excel Discussion (Misc queries) 2 April 27th 07 09:02 AM
validation list--list depends on the selection of first list Michael New Users to Excel 2 April 27th 06 10:23 PM
list 1 has 400 names List 2 has 4000. find manes from list 1 on 2 Ed Excel Worksheet Functions 5 September 12th 05 09:48 AM
find names on list 1 in list 2. list 1 4000 names list 2 400 name Ed Excel Worksheet Functions 1 September 4th 05 12:48 AM
sort list of players by team from player list on separate sheet Robert Excel Worksheet Functions 1 July 19th 05 01:57 AM


All times are GMT +1. The time now is 12:18 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"