WorksheetFunction.Vdb Method

  • Article

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.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Function Vdb ( _
    Arg1 As Double, _
    Arg2 As Double, _
    Arg3 As Double, _
    Arg4 As Double, _
    Arg5 As Double, _
    Arg6 As Object, _
    Arg7 As Object _
) As Double
'Usage
Dim instance As WorksheetFunction
Dim Arg1 As Double
Dim Arg2 As Double
Dim Arg3 As Double
Dim Arg4 As Double
Dim Arg5 As Double
Dim Arg6 As Object
Dim Arg7 As Object
Dim returnValue As Double

returnValue = instance.Vdb(Arg1, Arg2, _
    Arg3, Arg4, Arg5, Arg6, Arg7)

double Vdb(
    double Arg1,
    double Arg2,
    double Arg3,
    double Arg4,
    double Arg5,
    Object Arg6,
    Object Arg7
)

Parameters

  • Arg2
    Type: System.Double

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

  • Arg3
    Type: System.Double

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

  • Arg4
    Type: System.Double

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

  • Arg5
    Type: System.Double

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

  • Arg6
    Type: System.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
    Type: System.Object

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

Return Value

Type: System.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.

See Also

Reference

WorksheetFunction Interface

WorksheetFunction Members

Microsoft.Office.Interop.Excel Namespace