+ Reply to Thread
Results 1 to 3 of 3

Need formula to calculate average monthly percentage of change...

  1. #1
    vikgarden
    Guest

    Need formula to calculate average monthly percentage of change...

    Not sure how to do this, If I have a range of numbers, (50, 55, 75, 100)
    Percentage of increase is (10%, 36%, 33%)
    Average monthly increase is 26%

    How do I get excel to calculate the above?



  2. #2
    K Dales
    Guest

    RE: Need formula to calculate average monthly percentage of change...

    If you need to do it in one step, you will need a custom function I think.
    but if you can insert a calculated column (or row), you can use that to
    calculate the monthly increase for each of the values, then take the average
    of that column; for example if your monthly numbers are in A1:A4, then in B2
    put the formula =(A2-A1)/A1 and copy this down into B3 and B4. Then the
    average monthly increase is just =AVERAGE(B2:B4).

    "vikgarden" wrote:

    > Not sure how to do this, If I have a range of numbers, (50, 55, 75, 100)
    > Percentage of increase is (10%, 36%, 33%)
    > Average monthly increase is 26%
    >
    > How do I get excel to calculate the above?
    >
    >


  3. #3
    Bob Phillips
    Guest

    Re: Need formula to calculate average monthly percentage of change...

    =AVERAGE((B1:D1-A1:C1)/A1:C1)

    assuming the numbers are in A1:d1. This is an array formula so commit with
    Ctrl-Shift-Enter

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "vikgarden" <[email protected]> wrote in message
    news:[email protected]...
    > Not sure how to do this, If I have a range of numbers, (50, 55, 75, 100)
    > Percentage of increase is (10%, 36%, 33%)
    > Average monthly increase is 26%
    >
    > How do I get excel to calculate the above?
    >
    >




+ 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