Learn How to Use Microsoft Excel VDB Function

Microsoft Excel VDB Function

The main purpose of the Microsoft Excel VDB function is to get the depreciation for the double-declining variable. That implies, with the help of the VDB function you can able to return the depreciation of an asset for the given period. In this function, the double-declining balance method or another method is used which is specified by changing the factor argument. It should be noted that the VDB function will switch to a straight-line calculation by default. VDB is the abbreviation for the variable declining balance. So, with the help of the VDB function, you can able to get depreciation for the double-declining variable.

Return Value of VDB Function

The return value will be the depreciation for the specified period. 

Syntax of VDB Function

=VDB(cost, salvage, life, start, end, [factor], [no-switch])

Where the arguments:

• cost: This is the initial cost of the asset.
• salvage: This is the asset value at the end of the depreciation.
• life: This is the period over which an asset is depreciated.
• start: This is the start period.
• end: This is the end period.
• factor: This is the rate at which the balance declines, and In case omitted, defaults to 2 (optional).
• no-switch: It doesn't switch to the straight line, and the default is FALSE (optional).

How to Use Microsoft Excel VDB Function?

So we know that Microsoft Excel VDB function you can able to get the depreciation for the double-declining variable. That implies, with the help of the VDB function you can able to return the depreciation of an asset for the given period. In this function, the double-declining balance method or another method is used which is specified by changing the factor argument. It should be noted that the VDB function will switch to the straight-line calculation by default. VDB is the abbreviation for the variable declining balance. So, with the help of the VDB function, you can able to get depreciation for the double-declining variable.

Check out the list of all other articles:

• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel
• Learn How to Sort Birthdays by Month and DAY in Microsoft Excel