Ask Experts Questions for FREE Help !
Ask
    chrissbrady's Avatar
    chrissbrady Posts: 1, Reputation: 1
    New Member
     
    #1

    Feb 2, 2009, 02:13 PM
    Moving Percentages
    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's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #2

    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.

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

What are the percentages? [ 2 Answers ]

There is a total of 43 men, 36-masculine, 1-feminine and 6-neutral, What is the percentage of those that are masculine, feminine and neutral?:confused:

Tax percentages for F1 and H1B [ 2 Answers ]

Hello, Here are my questions: 1) I was working from January 08 to July 08 (in Washingtong DC) part-time on campus on my F1 student Visa. The university took out both federal and state taxes from my paycheck. Can you please tell me what are the percentages for each of the state and federal...

Percentages [ 1 Answers ]

Does any one know? % of the European economy that is derived from “family run or private businesses”.

Percentages [ 1 Answers ]

A Certain Brass Alloy Contains 60% Copper , 34% Zinc, And 6% Lead. How Many Kg Of This Brass Alloy And Of Zinc Must Be Added To 20 Kg Of Lead To Produce A New Brass Alloy That Is 40% Zinc And 8% Lead. Thanks

Percentages [ 1 Answers ]

If a train travells at a speed of 32kph and has to travel 564miles then stops and goes on to a different station at 58kph and has to travel 435miles how long will the whole trip take. Are you :confused:


View more questions Search