WorksheetFunction.Syd method (Excel)
Returns the sum-of-years' digits depreciation of an asset for a specified period.
Syntax
expression.Syd (Arg1, Arg2, Arg3, Arg4)
expression A variable that represents a WorksheetFunction object.
Parameters
| 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. |
Return value
Double
Remarks
SYD is calculated as follows: 
Support and feedback
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.