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

1. ## 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. ## 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. ## 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" <vikgarden@discussions.microsoft.com> wrote in message
news:3953C995-AC19-4443-957F-BC7A06AF4AF3@microsoft.com...
> 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?
>
>

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### 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