PDURATION function
PDURATION returns how many periods it takes for money to grow from one amount to another at a fixed rate, with no regular payments. It is simpler than NPER for lump sums.
Example
Read it as a sentence: find how many periods it takes an investment to grow from 2000 to 2200 at 2.5% per period, which gives 3.85986616262266.
A
B
C
D
1
3.85986616262266
2
3
Syntax
PDURATION(rate, pv, fv)
-
rate(required) - Interest rate per period.
-
pv(required) - Present value.
-
fv(required) - Future value wanted.
Returns: Periods needed for an investment to reach a target value.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=PDURATION(0.05,1000,2000) | 14.20669908 | Double at 5% |
=PDURATION(0.05,2000,1000) | -14.20669908 | Fv < pv |
=PDURATION("0.05","1000","2000") | 14.20669908 | Text number |
=PDURATION({0.05,0.1},1000,2000) | 14.20669908 | Spill |
=PDURATION(0,1000,2000) | #NUM! | Rate 0 |
=PDURATION(-0.05,1000,2000) | #NUM! | Rate negative |
=PDURATION(0.05,0,2000) | #NUM! | Pv 0 |
=PDURATION(0.05,-1000,-2000) | #NUM! | Negative values |
Watch out for
- rate, pv and fv must all be positive.
Where it works
- Excel
- PDURATION arrived in Excel 2013. Older versions do not have it.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Financial functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .