+ Reply to Thread
Results 1 to 2 of 2

Percentage added to a previous number

  1. #1
    Registered User
    Join Date
    05-17-2015
    Location
    canada
    MS-Off Ver
    -
    Posts
    1

    Percentage added to a previous number

    Hello, does anyone know how to do this simple excel calculation... i'm having difficulty with it. I want to do the following..
    cell A1 : place a variable % number (say for ex 6%)
    Cell A2: enter initial $ amount (say $200)
    Cell A3 : This would be week 1 : i want the total to appear $212.... which is obviously ($200+6%) ... I got it to work till here. my problrm is the following weeks. I just want to select the subsequent 52 cells for 52 weeks and have each week see the result with the % (cell A1) number added to the previous week. If i decide to change the % number in cell A1 i want all the 52 weeks to be updated automatically so i may see what it would be at any given week. If anyone is interested I can send you my excell file i'm trying out.
    Thanks

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Percentage added to a previous number

    Is this what you want?

    A3 and copy down.

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Click the * Add Reputation button in the lower left hand corner of this post to say thanks.

    Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

+ 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. [SOLVED] Added percentage markup and need help add to grand total...too many formulas!
    By trfountain22 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-14-2015, 12:51 PM
  2. percentage change from previous cell over a column.
    By spoon76 in forum Excel General
    Replies: 2
    Last Post: 10-09-2014, 04:31 PM
  3. [SOLVED] Weekly Sales Increase Percentage Added for a YTD %
    By Dhaark in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-28-2014, 02:36 PM
  4. Userform: one row added to wb, need to add new row if required (by previous row)
    By CRIMEDOG in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-13-2010, 12:27 PM
  5. Replies: 2
    Last Post: 01-31-2008, 07:20 PM

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