View Single Post
  #2   Report Post  
CarlosAntenna
 
Posts: n/a
Default


If you have your data in column A

50
55
75
100

In b2 enter =a2/a1-1
fill down the column
In b5 enter =average(b2:b5)
format column B as percentage

-- Carlos


"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?