Percentage increase in excel
 

Hi,

I have a column showing profit over one year and i would like to
calculate the percentage increase each month.

For example my columns might be as follows.

Jan - £3000
Feb - £4500
Mar - £7000
Apr - £9000
etc.

So i need to calculate the percentage increase from Jan to Feb and so
on.

Does anybody know the formula?

Thanks


--
fibregrid
------------------------------------------------------------------------
fibregrid's Profile: http://www.excelforum.com/member.php...o&userid=25707
View this thread: http://www.excelforum.com/showthread...hreadid=401911

fibregrid Wrote:
Hi,

I have a column showing profit over one year and i would like to
calculate the percentage increase each month.

For example my columns might be as follows.

Jan - £3000
Feb - £4500
Mar - £7000
Apr - £9000
etc.

So i need to calculate the percentage increase from Jan to Feb and so
on.

Does anybody know the formula?

Thanks

Enter this formula in Cell B2 (corresponding to the month of February)
and copy down until Cell B12.

*=(B2-B1)/B1 *

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=401911