Returns the number of periods required for an investment to reach a specified value.
이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
PDURATION(rate, pv, fv)The PDURATION function calculates the number of periods needed for an investment to reach a target future value at a constant interest rate. It is useful for financial planning when you need to determine how long it will take for an initial investment to grow to a specific amount.
=PDURATION(0.05, 1000, 2000)결과: 14.2067
Calculates the number of periods required for 1000 to grow to 2000 at a 5% interest rate.
If the rate is 0, the function will return a #NUM! error because the investment value will never change.