View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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?