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