This FAQ covers 3 common question types about the PDURATION function, including error handling, result checking, and filling the formula across multiple cells.
FAQ
What should I do if PDURATION returns #VALUE!?
- Check whether any argument contains text, extra spaces, or invalid characters.
- Make sure the referenced cells are formatted as numeric values.
- Clean the source data if needed, then enter the formula again.
Why is the PDURATION result different from what I expected?
- Check whether
rate,pv, andfvpoint to the correct cells. - Make sure the units and input basis are consistent.
- Confirm that the argument order is
rate, pv, fv.
How can I use PDURATION in multiple cells at once?
- Enter the full formula in the first cell.
- Select that cell and drag the fill handle across the target range.
- After filling, check whether relative or absolute references behave as expected.
Glossary
| Term | Definition |
|---|---|
| PDURATION | A financial function used to calculate how many periods are needed for an investment to grow from a present value to a target future value. |
| rate | The interest rate argument that represents the growth rate per period. |
| pv | The present value argument that represents the current amount. |
| fv | The future value argument that represents the target amount. |