描述
PDURATION函数返回投资达到指定值所需的周期数。
PDURATION使用以下公式-
$$PDURATION =\frac {log\left(指定值\right)-log\left(currentValue\right)} {log\left(1 + rate\right)} $$
Where
- specifiedValue等于fv
- currentValue等于pv
语法
PDURATION (rate, pv, fv)
争论
Argument | 描述 | Required/Optional |
---|---|---|
Rate | Rate is the interest rate per period. | Required |
Pv | Pv is the present value of the investment. | Required |
Fv | Fv is the desired future value of the investment. | Required |
Notes
-
PDURATION要求所有参数均为正值。
-
如果任何参数值为零或负,则PDURATION返回#NUM!错误值。
-
如果任何参数都不能识别为数值,则PDURATION将返回#VALUE!错误值。
适用性
Excel 2013,Excel 2016
Example
参考链接
https://www.learnfk.com/javascript/advanced-excel-financial-pduration-function.html
标签:JavaScript,log,PDURATION,Required,无涯,rate,right,left From: https://blog.51cto.com/u_14033984/7443710