| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Incresing % per annum
Hi
could anyone help, how would I get a cell containing a total figure to increase by 5% per annum, thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Incresing % per annum
Let's say your total figure is in cell A1. In A2 enter this formula:
=1.05*A1 and copy down the column. Each cell down the column will 5% more than the cell above it. -- Gary's Student "devonguy" wrote: Hi could anyone help, how would I get a cell containing a total figure to increase by 5% per annum, thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| rate of return on investment per annum | Excel Discussion (Misc queries) | |||
| Incresing date incrimentaly | Excel Discussion (Misc queries) | |||
| $20,000 due. Pays diff $ every x. Int calc per annum. Need excel . | Excel Worksheet Functions | |||
Linear Mode
