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.