+ Reply to Thread
Results 1 to 5 of 5

Formula help for working out percentage change

  1. #1
    Registered User
    Join Date
    06-04-2015
    Location
    Leicester, United Kingdom
    MS-Off Ver
    Office 2010
    Posts
    3

    Formula help for working out percentage change

    Hi guys

    Appreciate some help if possible please? I'm usually good at sorting these out, and they're normally quite straightforward but this one has got me - just cannot see the wood for the trees.

    Screenshot example below:

    First row, the change in reported savings since previous week should show a 10% growth, not -1000%. Any ideas?
    The next two rows are correct at 100% because the savings have doubled in size.

    Can anyone advise of a formula that shows the 10% growth and also the 100% growth if I drag the formula down to the row below?

    Many thanks in advance, much love

    Example - Example.xlsx
    Attached Images Attached Images
    Last edited by el_lloydie; 06-04-2015 at 06:45 AM.

  2. #2
    Forum Contributor jayajaya_4's Avatar
    Join Date
    05-09-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    259

    Re: Formula help for working out percentage change

    try this in =ABS(D2-A2)/D2 or =(ABS(D2-A2)/D2)/100 in E2
    see if this helps u
    Last edited by jayajaya_4; 06-04-2015 at 07:06 AM.

  3. #3
    Registered User
    Join Date
    06-04-2015
    Location
    Leicester, United Kingdom
    MS-Off Ver
    Office 2010
    Posts
    3

    Re: Formula help for working out percentage change

    Hi,

    Managed to get an example inserted to my original post.

    Many thanks,
    Gareth

  4. #4
    Forum Contributor jayajaya_4's Avatar
    Join Date
    05-09-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    259

    Re: Formula help for working out percentage change

    hey pls check the updated answer above Gareth

  5. #5
    Registered User
    Join Date
    06-04-2015
    Location
    Leicester, United Kingdom
    MS-Off Ver
    Office 2010
    Posts
    3

    Re: Formula help for working out percentage change

    Thanks, think it's worked

+ 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] Percentage Allocation Formula not working
    By Shaun Gemiver in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-15-2013, 05:14 AM
  2. Percentage Completion Bar Formula not working
    By chriseverclear in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-25-2012, 12:29 PM
  3. Replies: 0
    Last Post: 10-11-2012, 11:38 AM
  4. Change a percentage formula
    By shug1986 in forum Excel General
    Replies: 3
    Last Post: 07-04-2012, 02:29 PM
  5. Percentage formula not working?
    By mitelkm in forum Excel General
    Replies: 1
    Last Post: 11-12-2007, 04:11 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