UDF for Depreciation

[odysseyoflife]

Hello,

I want to define a UDF for calculating periodic depreciation charge, as
and when assets are added or depleted, for my models.

Main theme is to pass a range(s) to the function for addition and
depletion of asset along with the 'life of asset' (selected via lookup
function from 'Depreciatoin Category list) as argument and use array
method to calculate the depreciation charge for the period.

Can anyone please guide me?

Thanks

O.