numbering lines

[Thomas]

I have a column of numbers starting on row 20...each number represents the
rent due for one month...row 20 is month 1...I am trying to increase the rent
by 2% starting with the first month of each new year...in other words, the
rent would be $100 for months 1-12, $102 for months 13-24, $104 for months
25-36, etc...if I could simply add a helper column and number the lines 1-12,
1-12, 1-12, etc. maybe thats a start
Thanks

 

[Ken Wright]

Put your data in say A20:A31 for the first 12 months.

Now in A32, put =A20*1.02 and copy down as many rows as necessary till you
get as far as you need.

Better yet, put the 2% in a separate cell, eg B1, and then use in A32
=A20*$B$1

Regards
Ken........................

 

[Thomas]

thanks Ken

Put your data in say A20:A31 for the first 12 months.

Now in A32, put =A20*1.02 and copy down as many rows as necessary till you
get as far as you need.

Better yet, put the 2% in a separate cell, eg B1, and then use in A32
=A20*$B$1

Regards
Ken........................

 

[Ken Wright]

You're very welcome

thanks Ken