I'm working on a Straight Line Depreciation Spreadsheet (this was a "Home
Grown" effort -- touched by many hands, and not derived from an Excel
Template/Example)

Basically, I have the following ...
Cost (CELL M2) -- Life, in months (CELL L2) -- In-Service Date (CELL J2) --
Depreciation per month (CELL N2) -- Life/Cost)

Beginning 01/01/2005, I have an "Accumulated Depreciation Total" (CELL O2)
and the logic I want to apply is this:

IF Value in Cell O2 < Cost (CELL M2) then I want to populate CELL P2 with
the value of CELL P2 + the Monthly Depreciation (CELL N2) and continue this
on out (giveing an Accumulated Depreciation Total 12/31/06 and each
end-of-year until the value in any subsequent cell is equal to the Cost
(CELL M2).

Is there some code that I could use to manage this? For example (based on
the Life -- 60 months, 120 months, ect. -- Auto Fill the appropriate number
of cells to the right to correspond with the number of months in the Life
Cycle.

Thanks in advance for any assistance in this troubling problem.

see response to your posting in public.excel

--
Regards

Roger Govier


"doctorjones_md" <doctorjones_md(Remove wrote in
message ...
I'm working on a Straight Line Depreciation Spreadsheet (this was a
"Home Grown" effort -- touched by many hands, and not derived from an
Excel Template/Example)

Basically, I have the following ...
Cost (CELL M2) -- Life, in months (CELL L2) -- In-Service Date (CELL
J2) -- Depreciation per month (CELL N2) -- Life/Cost)

Beginning 01/01/2005, I have an "Accumulated Depreciation Total" (CELL
O2) and the logic I want to apply is this:

IF Value in Cell O2 < Cost (CELL M2) then I want to populate CELL P2
with the value of CELL P2 + the Monthly Depreciation (CELL N2) and
continue this on out (giveing an Accumulated Depreciation Total
12/31/06 and each end-of-year until the value in any subsequent cell
is equal to the Cost (CELL M2).

Is there some code that I could use to manage this? For example
(based on the Life -- 60 months, 120 months, ect. -- Auto Fill the
appropriate number of cells to the right to correspond with the number
of months in the Life Cycle.

Thanks in advance for any assistance in this troubling problem.

Thank you Roger -- I'll give that a try this morning and post back here on
the results.


"Roger Govier" wrote in message
...
see response to your posting in public.excel

--
Regards

Roger Govier


"doctorjones_md" <doctorjones_md(Remove wrote in message
...
I'm working on a Straight Line Depreciation Spreadsheet (this was a "Home
Grown" effort -- touched by many hands, and not derived from an Excel
Template/Example)

Basically, I have the following ...
Cost (CELL M2) -- Life, in months (CELL L2) -- In-Service Date (CELL
J2) -- Depreciation per month (CELL N2) -- Life/Cost)

Beginning 01/01/2005, I have an "Accumulated Depreciation Total" (CELL
O2) and the logic I want to apply is this:

IF Value in Cell O2 < Cost (CELL M2) then I want to populate CELL P2 with
the value of CELL P2 + the Monthly Depreciation (CELL N2) and continue
this on out (giveing an Accumulated Depreciation Total 12/31/06 and each
end-of-year until the value in any subsequent cell is equal to the Cost
(CELL M2).

Is there some code that I could use to manage this? For example (based
on the Life -- 60 months, 120 months, ect. -- Auto Fill the appropriate
number of cells to the right to correspond with the number of months in
the Life Cycle.

Thanks in advance for any assistance in this troubling problem.