Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
inserted lines move how to place lines in proper cell? | Excel Worksheet Functions | |||
PO with sequential numbering with start / end numbering | Excel Discussion (Misc queries) | |||
Inserting Lines or Copying lines with formulas but without data | Excel Discussion (Misc queries) | |||
Need help in numbering a column while skipping lines | Excel Worksheet Functions | |||
Numbering lines | New Users to Excel |