Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I calculate an average by a certain percentage? | Excel Worksheet Functions | |||
calculate/convert volume price to monthly average price | Excel Worksheet Functions | |||
calculate average in percentage coloumn with #DIV/! (ignore error | Excel Discussion (Misc queries) | |||
calculate monthly average percentage of change | Excel Worksheet Functions | |||
How do I create a formula to calculate the average percentage rat | Excel Worksheet Functions |