描述
SLN函数返回资产在一个期间内的直线折旧。
语法
SLN (cost, salvage, life)
争论
| Argument | 描述 | Required/Optional |
|---|---|---|
| Cost | The initial cost of the asset. | Required |
| Salvage | The value at the end of the depreciation (sometimes called the salvage value of the asset). | Required |
| Life | The number of periods over which the asset is depreciated (sometimes called the useful life of the asset). | Required |
Notes
-
如果指定的寿命参数为0,则SLN返回#DIV/0!错误。
-
如果任何指定的寿命参数是非数字值,则SLN返回非数字值Error。
适用性
Excel 2007,Excel 2010,Excel 2013,Excel 2016
Example
