+ Reply to Thread
Results 1 to 7 of 7

Increasing a percentage on values

  1. #1
    Registered User
    Join Date
    10-12-2011
    Location
    Bangkok, Thailand
    MS-Off Ver
    Excel 2007
    Posts
    5

    Increasing a percentage on values

    Here is the problem:

    Increase the "cost of goods" by 12 percent for each month to account for the added goods needed to make brownies.

    My Question:

    Is there a formula I can create using "absolute reference" to show the increment in all columns?

    Thanks.

  2. #2
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,417

    Re: Increasing a percentage on values

    Could you post an example workbook?

    abousetta
    Please consider:

    Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
    Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.

  3. #3
    Registered User
    Join Date
    10-12-2011
    Location
    Bangkok, Thailand
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Increasing a percentage on values

    Here it is... I have highlighted the "Cost of goods" row for quick reference.

    Thanks!
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,417

    Re: Increasing a percentage on values

    So far I see that you have added the cost of good manually. Is this what you want to automate and is it based on the number of cookies made or just a standard figure. Could you tell us how you imagine the formula would like in words.'

    abousetta

  5. #5
    Registered User
    Join Date
    10-12-2011
    Location
    Bangkok, Thailand
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Increasing a percentage on values

    I did indeed but would like to learn the formula if any... I want Excel to take the cost of goods value of each month and increment those values by 12 percent.

    Thanks!

  6. #6
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,417

    Re: Increasing a percentage on values

    Theoretically you would put this in C21 and drag to the right:

    Please Login or Register  to view this content.
    but the results are different from what you have in the other months so I am wondering how you came up with these figures.

    abousetta

  7. #7
    Registered User
    Join Date
    10-12-2011
    Location
    Bangkok, Thailand
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Increasing a percentage on values

    This is a "forecasting sales" homework I'm doing. It consists in different steps from a through q. This particular question is "d." Since I am doing it step by step I am assuming the numbers in the spreadsheet I sent you are wrong so we can go back and fix the errors. I will keep going and get back to you if needed.

    This forum is very helpful. Thank you for your time.

    One last question:

    What do I do to calculate the value in colum "A"?

    Many thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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