The PDURATION function returns the number of periods required by an investment to reach a specified value.
- This function was introduced in Excel 2013 and so is not available in earlier versions.
|rate||The interest rate per period|
|pv||The present value of the investment|
|fv||The desired future value of the investment|
Note: PDURATION requires that all arguments are positive values.
|2||=PDURATION(2.5%,2000,2200)||3.86||The number of years required for an investment of $2,000, earning 2.5% annually, to reach $2,200|
|3||=PDURATION(0.025/12,1000,1200)||87.6||The number of months required for an investment of $1,000, earning 2.5% annually, to reach $1,200|
Note: In the example, the annual interest rate of 2.5% in A3 had to be converted into a monthly rate (=0.025/12)
Common Function Error(s)
|Problem||What went wrong|
|#VALUE!||Occurs if any of the supplied arguments are not recognized as numeric values|
|#NUM!||Occurs if any of the supplied arguments are zero or negative|