WorksheetFunction.Sln Method (Excel)
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