描述
SYD函数返回指定期间资产的年折旧数字。
语法
SYD (cost, salvage, life, per)
争论
| 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 |
| Per | The period and must use the same units as life. | Required |
Notes
-
SYD的计算如下-
$$SYD =\frac {\left(成本-残废权\right)*\left(生命-每+1\right)* 2} {\left(life\right)\left(life + 1\right)} $$
If the specified salvage argument is < 0, SYD returns #NUM! error.
如果指定寿命或每个参数指定的值≤0,则SYD返回#NUM!错误。
如果指定的per大于指定的寿命参数,则SYD返回#NUM!错误。
如果任何指定的值都是非数字的,则SYD返回#VALUE!。错误。
适用性
Excel 2007,Excel 2010,Excel 2013,Excel 2016
Example
