編輯

共用方式為


WorksheetFunction.Sln(Double, Double, Double) Method

Definition

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

public:
 double Sln(double Arg1, double Arg2, double Arg3);
public double Sln (double Arg1, double Arg2, double Arg3);
Public Function Sln (Arg1 As Double, Arg2 As Double, Arg3 As Double) As Double

Parameters

Arg1
Double

Cost - the initial cost of the asset.

Arg2
Double

Salvage - the value at the end of the depreciation (sometimes called the salvage value of the asset).

Arg3
Double

Life - the number of periods over which the asset is depreciated (sometimes called the useful life of the asset).

Returns

Applies to