WorksheetFunction.Syd method (Excel)
Returns the sum-of-years' digits depreciation of an asset for a specified period.
expression.Syd (Arg1, Arg2, Arg3, Arg4)
expression A variable that represents a WorksheetFunction object.
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Arg1 | Required | Double | Cost - the initial cost of the asset. |
| Arg2 | Required | Double | Salvage - the value at the end of the depreciation (sometimes called the salvage value of the asset). |
| Arg3 | Required | Double | Life - the number of periods over which the asset is depreciated (sometimes called the useful life of the asset). |
| Arg4 | Required | Double | Per - the period and must use the same units as life. |
Double
SYD is calculated as follows: 
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.