+ Reply to Thread
Results 1 to 4 of 4

Want to create a formula to perform increases down the cells by a certain percentage

  1. #1
    Registered User
    Join Date
    09-28-2013
    Location
    Marion County, FL
    MS-Off Ver
    Excel 2010
    Posts
    1

    Want to create a formula to perform increases down the cells by a certain percentage

    I hope this is easy, I just don't know how.

    My spreadsheet has 1.04 in cell D2. It has 24000 in cell D3. My cells go all the way down to D37. I can create a formula for cell D4, for example, that increases D3 by 4%: ROUND(D3*D2). So D4= 24960.

    And so on, cell D5 increases cell D4 by the 1.04: ROUND(D4*D2). So D5= 25958, and so on.

    This feels like there has got to be a way to automate this - instead of repeating the formula with its little cell number change for each and every cell, placing ONE formula statement somewhere for the whole procedure.

    The point is to increase each cell by a fixed percentage over the previous one. Can anyone teach me this? Thank you.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Want to create a formula to perform increases down the cells by a certain percentage

    Hi and welcome to the forum

    you could try this...
    =ROUND(D3*$D$2)

    copy this down with either click-hold the small square on the bottom right corner of the cell, and dragging down, or double-click on the the small square on the bottom right corner. The $ absolutes the cell ref so it doesnt change when copied
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    09-25-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Want to create a formula to perform increases down the cells by a certain percentage

    You do not need to have 1.04 in any cell.

    All you need to do is A1=24000.

    Then A2=Round(A1*1.04) and drag it down.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Want to create a formula to perform increases down the cells by a certain percentage

    syj, I agrre with you, however, referencing a cell instead, allows for easy adjustment of the value

+ 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. Macro that increases a cell value by a certain percentage
    By Jehanzaib in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-24-2013, 07:55 AM
  2. [SOLVED] LINESTIF - Can you help me create an array formula to perform this function without VBA?
    By jglassmanba in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-26-2012, 05:45 PM
  3. Need to create percentage calculation formula
    By TruSake in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-11-2012, 04:58 PM
  4. Replies: 8
    Last Post: 06-05-2012, 01:16 PM
  5. How to record percentage increases in materials costing sheet.
    By onesonya in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 07-07-2005, 03:05 AM

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