Excel Functions

Excel PDURATION Function

Pinterest LinkedIn Tumblr

The Excel PDURATION stands for the periodic duration. It is categorized under financial functions, wherein PDURATION calculates the number of periods required by an investment to reach the specified value in the future.

Purpose of Excel PDURATION Function

To get the number of periods required to reach the specified value in the future.

Return value

PDURATION function returns the required time in periods.

Syntax

=PDURATION(rate, pv, fv)

Arguments

ArgumentsDescriptionRemarks
rateRate is the interest rate per period. Mandatory
pvPv is the present value of the investment. Mandatory
fvFv is the desired future value of the investment. Mandatory

Usage note

  • PDURATION requires that all arguments are positive values.
  • If argument values are not valid, PDURATION returns the #NUM! error value.
  • If arguments are not using valid data types, PDURATION returns the #VALUE! error value.

Availability

Since 2007 for Windows.
Since 2011 for Mac.

Related Posts

Write A Comment