M
Maxine
In a formula relative to straight line depreciation, I have to cells I need
to fill in with formulas. The first cell requires the first year of the
total useful life of the asset. The acquisition date is taken from a
vlookup. The first cell would be a year's worth of depreciation less one
month.
The second cell requires the next full year's amount of depreciation.
The project requires that when you click on a specific asset, the column
lists all the years depreciation starting with the first year in the first
cell of the column to the last year.
I know this sounds confusing, but can you help?
to fill in with formulas. The first cell requires the first year of the
total useful life of the asset. The acquisition date is taken from a
vlookup. The first cell would be a year's worth of depreciation less one
month.
The second cell requires the next full year's amount of depreciation.
The project requires that when you click on a specific asset, the column
lists all the years depreciation starting with the first year in the first
cell of the column to the last year.
I know this sounds confusing, but can you help?