+ Reply to Thread
Results 1 to 9 of 9

Percentage Growth between two years

  1. #1
    Registered User
    Join Date
    03-03-2010
    Location
    australia
    MS-Off Ver
    Excel 2003
    Posts
    4

    Percentage Growth between two years

    Hi There,

    We are trying to work out the growth in net revenue between two years. I have been told that by using the standard formula of

    (Year 2 - Year 1) / ABS (Year 2) is not the correct formula to use in this context, especially when it comes to negative numbers.

    Our growth between years can differ quite a lot.

    Year 1 Year 2 Difference % Difference
    $106,523 $(44,222) $(150,744) (142)%
    $115,133 $63,758 $(51,375) (55)%
    $184,457 $405,797 $221,340 120%
    $140,421 $16,384 $(124,037) 88%

    I have been advised that the % differences that I am showing using the above formula is not correct. Please help

    Thanks

  2. #2
    Forum Contributor
    Join Date
    01-28-2010
    Location
    Pittsburgh, PA
    MS-Off Ver
    Excel 2013
    Posts
    200

    Re: Percentage Growth between two years

    Hmmm, Percent difference is usually to get the right sign:

    (Year 2 - Year 1)/Year 1

  3. #3
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,677

    Re: Percentage Growth between two years

    There is no meaningful calculation of YoY difference if the prior year is zero or negative. Financial journals agree.
    Entia non sunt multiplicanda sine necessitate

  4. #4
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Cool Re: Percentage Growth between two years

    Hi
    welcome to the forum..
    Check the attached file..
    Attached Files Attached Files
    Regards,
    Vikas Gautam
    Excel-buzz.blogspot.com

    Excel is not a matter of Experience, its a matter of Application.

    Say Thanks, Click * Add Reputation

  5. #5
    Registered User
    Join Date
    03-03-2010
    Location
    australia
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Percentage Growth between two years

    Thanks - Appreciate your help and kindnes
    Last edited by debbiesap; 10-22-2014 at 02:36 AM.

  6. #6
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: Percentage Growth between two years

    Thanks for the reply and reputation point as well...

  7. #7
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Cool Re: Percentage Growth between two years

    Check the attached file..
    Read explanations as well..
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    03-03-2010
    Location
    australia
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Percentage Growth between two years

    Perfect :-)

    Thanks very much, I will try it in real life and see if that is what they want. Hope you don't mind if I have any questions but it make sense to me.

    Thanks again you very kind

  9. #9
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: Percentage Growth between two years

    Thanks for the reply..

+ 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. Replies: 8
    Last Post: 02-02-2020, 01:39 AM
  2. Replies: 6
    Last Post: 09-17-2019, 07:04 AM
  3. Percentage of Growth Calculation
    By yuzi in forum Excel General
    Replies: 6
    Last Post: 07-16-2009, 12:47 PM
  4. Growth Percentage YTD
    By Naggers in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-12-2008, 12:05 PM
  5. determine percentage of growth
    By restore in forum Excel General
    Replies: 5
    Last Post: 04-05-2005, 09:06 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