Average % - this should be easy?
in [Functions]
|
From: Vixter on 26 Jan 2010 05:01 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.
From: Jacob Skaria on 26 Jan 2010 05:13 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.
From: Vixter on 26 Jan 2010 05:27 Hi Jacob. You really are an excel boffin - It never crossed my mind to add an extra column. I do have a cell that calculates the increase from the last month but your way works better. Thanks. "Jacob Skaria" wrote: > 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.
|
Pages: 1 Prev: lookup function Next: some kind of Conditional format? - Baffled :( |