+ Reply to Thread
Results 1 to 2 of 2

changing percentages equal across 12 months

  1. #1
    Registered User
    Join Date
    04-14-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    83

    changing percentages equal across 12 months

    I am working on a budget. We are budgeting the amount of money that we are going to place into savings each month based on the amount of sales that are budgeted each month. So if we are placing $100,000 a year into savings we will place a different percentage of that $100,000 each month. I want to adjust the dollar amount for one or two months and have the percentages change accordingly or at least the remaining months dollars change so that I still come up with $100,000 at the end of the year.
    Capture.PNG
    Attached Files Attached Files

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,623

    Re: changing percentages equal across 12 months

    B7:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    and copy right
    or (as sum in row 5 ais always 100%) shorter version:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Is it what you look for? Because formula in row 7 do not reflect row 8 header? You also say about adjusted dollar amount in the description ...
    Last edited by Kaper; 10-16-2017 at 08:55 AM.
    Best Regards,

    Kaper

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Changing percentages
    By thursday140 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-04-2017, 02:55 PM
  2. Running percentages with changing denominators
    By kwicks89 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-26-2014, 12:21 PM
  3. Return the months that is not equal to my criteria
    By rarementality in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 01-01-2014, 12:00 AM
  4. changing positive and negative numbers to percentages to equal zero
    By dabears50 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-07-2013, 07:48 PM
  5. [SOLVED] Formula combination amounts in equal frequency over 12 months
    By Derek Cavanagh in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-24-2013, 04:36 AM
  6. Changing an exsisting chart to percentages.
    By Lorna B in forum Excel General
    Replies: 6
    Last Post: 03-08-2012, 08:33 AM
  7. Changing percentages based on text value
    By jar546 in forum Excel General
    Replies: 2
    Last Post: 04-22-2010, 08:19 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1