ExcelBanter - Incresing % per annum

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Incresing % per annum (https://www.excelbanter.com/excel-worksheet-functions/118421-incresing-%25-per-annum.html)

devonguy

Incresing % per annum

Hi
could anyone help, how would I get a cell containing a total figure to
increase by 5% per annum, thanks

Gary''s Student

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

All times are GMT +1. The time now is 01:12 PM.