Incresing % per annum

D

devonguy

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

Gary''s Student

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.
 
Top