Expand Minimize

WorksheetFunction.PDuration Method (Excel)

Office 2013

Published: July 16, 2012

Returns the number of periods required by an investment to reach a specified value.

Version Added: Excel 2013

expression .PDuration(Arg1,Arg2,Arg3)

expression A variable that represents a WorksheetFunction Object (Excel) object.

Parameters

Name

Required/Optional

Data type

Description

Arg1

Required

DOUBLE

Interest rate per period.

Arg2

Required

DOUBLE

Present value of the investment.

Arg3

Required

DOUBLE

Desired future value of the investment.

Return value

DOUBLE

Community Additions

ADD
Show:
© 2014 Microsoft