Edit

Share via


WorksheetFunction.PDuration(Double, Double, Double) Method

Definition

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

public:
 double PDuration(double Arg1, double Arg2, double Arg3);
public double PDuration (double Arg1, double Arg2, double Arg3);
Public Function PDuration (Arg1 As Double, Arg2 As Double, Arg3 As Double) As Double

Parameters

Arg1
Double

Interest rate per period.

Arg2
Double

Present value of the investment.

Arg3
Double

Desired future value of the investment.

Returns

DOUBLE

Applies to