| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| I want to select excel cells of difference colors and increase th. | Excel Worksheet Functions | |||
| how do I up a percentage formual in excel | Excel Discussion (Misc queries) | |||
| Can Excel add a set percentage to a cell automatically when you type in a number | Excel Worksheet Functions | |||
Linear Mode
