WorksheetFunction.Sln Method
| Excel Developer Reference |
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
See Also