Formula with period (month) to change automatically

[rocku24]

I have an amortization schedule that I'm trying to automate to make the process less tedious. I'm trying to get the period (month) to change automatically once the month being reconciled is changed. For example the current formula is "=1200-100*2" indicating that we've amortized 2 months of expense. I would like to have a standard cell/formula that automatically changes that "2" to "3" when I get to March. How can I do this?

[Pete_UK]

Are you copying that formula across columns? If so you can use:

=1200-100*columns($A:B)

to return a factor of 2, and then when it is copied across this will change to 3, 4, 5 etc.

Hope this helps.

Pete

[Ace_XL]

Alternatively, you could use a defined name range (say 'Month') and change your formula to =1200-100*Month. This way you only have to update the defined name to reflect the month no. and the schedule will populate automatically.

Some help on defining names ...

http://office.microsoft.com/en-us/ex...010147120.aspx

[rocku24]

Guys,

Thanks a million, you guys are geniuses; this forum is the greatest invention since man discovered the wheel.

[Cutter]

@ rocku24

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.