DDB is for (Depreciation, double-declining)
DDB(cost as Double, salvage as Double, life as Double, period as Double[,
factor as Variant])
Returns a double containing the depreciation of an asset for a specified
time period using the double-declining method (or some other method you
specify).
In the double-declining method, depreciation is highest in the first period
and decrease in each successive period.
- cost is a double specifying initial cost of the asset.
- salvage is a double specifying the asset's value at the end of its useful
life.
- life is a double specifying the useful life of the asset. Must be
expressed in the same units as period.
- period is a double the period for which the depreciation is being
calculated. Must be expressed in the same units as life.
- factor is a variant specifying the rate at which the balance declines. Is
default value is 2 (specifying double-declining method).
The formula implemented for the DDB function for VB and VBA is:
DDB = ( ( (cost - salvage) * factor ) / life ) * period
Dont have an example, but hopefully this explanation will clarify it for you
:-)
With regards,
Stéphane Richard
"nkp" <we***********@btinternet.com> wrote in message
news:bo**********@hercules.btinternet.com...
Hello...looking for some examples of the DDB function to better
understand how it is used.Thanks