How to Use PDURATION() in Google Sheets

Description

Returns the number of periods for an investment to reach a specific value at a given rate..

How To Actually Use PDURATION() in Sheets

PDURATION(rate, present_value, future_value)

Try PDURATION yourself

In cells A1 to A3, enter the rate (0.05), present value (1000), and future value (2000) respectively. Use the PDURATION formula to calculate how many periods it will take for the investment to double in cell A4.

Your formula

Hints (2)

Locale Separator ,

Official Docs

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas

Transcript-matched member videos for PDURATION(). Click through to watch.

Browse more tutorials

Create a Stop Watch in a Google Sheet

We'll create a stop watch from scratch. Including Apps Script. What it w...

Write Apps Script to Create a New Google Sheets Formula

Create a brand new custom formula in Apps Script. We'll do this for our ...

Unlock these tutorials

Learn more about the PDURATION() formula:

Generate a PDURATION() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses PDURATION(). 2 free AI generations, no signup. Members get unlimited use.

Generate a PDURATION() formula

How to Use PDURATION() in Google Sheets

Try PDURATION yourself

More related tutorials

Create a Stop Watch in a Google Sheet

Write Apps Script to Create a New Google Sheets Formula