Formulas > =VDB()
How to Use VDB() in Google Sheets
Description
How To Actually Use VDB() in Sheets
VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch])
Try VDB yourself
In cells A1 to A3, enter the cost, salvage value, and useful life of an asset. Use the VDB formula in cell B1 to calculate the depreciation for the first year (period 1).
Hints (2)
-
Remember to reference the correct cells for cost, salvage, and life.
-
The start_period and end_period for the first year should both be 1.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the VDB() formula:
Generate a VDB() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses VDB(). 2 free AI generations, no signup. Members get unlimited use.
Generate a VDB() formula