WorksheetFunction.Vdb Method

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Returns the depreciation of an asset for any period you specify, including partial periods, using the double-declining balance method or some other method you specify. VDB stands for variable declining balance.

public double Vdb (double Arg1, double Arg2, double Arg3, double Arg4, double Arg5, object Arg6, object Arg7);

Public Function Vdb (Arg1 As Double, Arg2 As Double, Arg3 As Double, Arg4 As Double, Arg5 As Double, Optional Arg6 As Object, Optional Arg7 As Object) As Double

Parameters

Arg1: Double

Cost - the initial cost of the asset.

Arg2: Double

Salvage - the value at the end of the depreciation (sometimes called the salvage value of the asset). This value can be 0.

Arg3: Double

Life - the number of periods over which the asset is depreciated (sometimes called the useful life of the asset).

Arg4: Double

Start_period - the starting period for which you want to calculate the depreciation. Start_period must use the same units as life.

Arg5: Double

End_period - the ending period for which you want to calculate the depreciation. End_period must use the same units as life.

Arg6: Object

Factor - the rate at which the balance declines. If factor is omitted, it is assumed to be 2 (the double-declining balance method). Change factor if you do not want to use the double-declining balance method. For a description of the double-declining balance method, see Ddb(Double, Double, Double, Double, Object).

Arg7: Object

No_switch - a logical value specifying whether to switch to straight-line depreciation when depreciation is greater than the declining balance calculation.

Returns

Double

Remarks

If no_switch is true, Microsoft Excel does not switch to straight-line depreciation even when the depreciation is greater than the declining balance calculation.

If no_switch is false or omitted, Excel switches to straight-line depreciation when depreciation is greater than the declining balance calculation.

Applies to