课程: Excel: Financial Functions in Depth

今天就学习课程吧！

今天就开通帐号，24,100 门业界名师课程任您挑！

DDB: Depreciation using the double-declining balance method

DDB: Depreciation using the double-declining balance method - Microsoft Excel教程

课程: Excel: Financial Functions in Depth

开始一个月试用 购买团队方案

DDB: Depreciation using the double-declining balance method

“

- [Narrator] Now that we've calculated the fixed declining depreciation calculation using the DB, let's go ahead and try out the double declining using the DDB function. I'm going to use the dialogue box for this one. So we'll pick up the cost, the salvage, the life and the period. Now it's asking us for the factor, and if we leave it out it's going to assume that the factor is two which is the double declining balance method which is nearly always what we want when we use this function. So I'm going to just leave that one blank. Now that didn't automatically calculate down, and that's because I didn't put the hash at the end. So if I wanted to spill down using the dynamic array functionality I just need to put the hash at the end and that will automatically copy it down. Now, as I said earlier, this will only work if you're using Excel for Microsoft 365. If you are not using 365 then you can calculate the period…

内容