Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Apr 2008
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Man this seems so simple but I cant get it.

    I have 10 people who pay 2% of their annual income into a fund totaling $12000.

    I want to increase the total to $13000.

    I think thatís an 8% increase by person ((new-old)/old)*100

    If they are currently paying 2% of their annual income to get the $12000 what percent of their annual income do they now have to pay to get to $13000?

    What is the excel calc to determine that? I want to calculate the new number for column C. I have a file attached. Thanks for any help!

    Clarification Note: I want cell D12 to now match G2.
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You have calculated the increase in cell H15.
    The new percentage is 2% + H15*2% ~ 2.167%

  3. #3
    Lounger
    Join Date
    Apr 2008
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank you!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •