View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Average % - this should be easy?

With data arranged as below in cell C3 enter the below formula

=(B3-B2)/B2
and format the formula cell to %

Col A Col B Col C
Month Amount % increase
Jan-10 $50.00
Feb-10 $100.00 100%
Mar-10 $150.00 50%
Apr-10 $180.00 20%
May-10 $190.00 6%
Jun-10 $200.00 5%
Jul-10 $210.00 5%
Aug-10 $220.00 5%
Sep-10 $230.00 5%


--
Jacob


"Vixter" wrote:

Hi,
I work for a charity organisation. Every month we raise more money than the
previous month. Can someone assist with how to work out an average increase
over a few months. My donation amount column is formatted currency, but I
need the answer to be an average percentage increase.
Thanks.