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:   Formula

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.