Use the DDB function to calculate double-declining balance method
The DDB function returns the depreciation of an asset for a specified period, using the double-declining balance method or some other method that can be specified.
DDB(cost, salvage, life, period, factor)
cost: The asset’s initial cost.
salvage: The value of the asset at the end of the depreciation.
life: The number of periods over which the asset is being [...]