Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

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.

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

  • SYD is calculated as follows: awfsyd_ZA06051253

Show:
© 2015 Microsoft