Returns the sum-of-years' digits depreciation of an asset for a specified period.
ฟังก์ชันนี้ทำงานใน Google Sheets เหมือนกับใน Excel — ไวยากรณ์และอาร์กิวเมนต์เดียวกัน
SYD(cost, salvage, life, per)The SYD function calculates depreciation using the sum-of-years' digits method, which accelerates depreciation so that more expense occurs in the early years of an asset's life. This method is often used for assets that lose value quickly, such as vehicles or technology equipment.
=SYD(30000, 3000, 10, 1)ผลลัพธ์: 4909.09
Calculates the depreciation for the first year of an asset costing 30,000 with a 3,000 salvage value over 10 years.
The SYD function will return a #NUM! error.