Rediger

Del via

WorksheetFunction.Sln method (Excel)

  • Artikkel

Returns the straight-line depreciation of an asset for one period.

Syntax

expression.Sln (Arg1, Arg2, Arg3)

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).

Return value

Double

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.