numbering lines
 

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

numbering lines
 

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" wrote in message
...
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

numbering lines
 

thanks Ken

"Ken Wright" wrote:

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" wrote in message
...
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

numbering lines
 

You're very welcome

"Thomas" wrote in message
...
thanks Ken

"Ken Wright" wrote:

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" wrote in message
...
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