Compartilhar via

WorksheetFunction.NPer Method

  • Artigo

Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Function NPer ( _
    Arg1 As Double, _
    Arg2 As Double, _
    Arg3 As Double, _
    Arg4 As Object, _
    Arg5 As Object _
) As Double
'Usage
Dim instance As WorksheetFunction
Dim Arg1 As Double
Dim Arg2 As Double
Dim Arg3 As Double
Dim Arg4 As Object
Dim Arg5 As Object
Dim returnValue As Double

returnValue = instance.NPer(Arg1, Arg2, _
    Arg3, Arg4, Arg5)

double NPer(
    double Arg1,
    double Arg2,
    double Arg3,
    Object Arg4,
    Object Arg5
)

Parameters

  • Arg2
    Type: System.Double

    Pmt - the payment made each period; it cannot change over the life of the annuity. Typically, pmt contains principal and interest but no other fees or taxes.

  • Arg3
    Type: System.Double

    Pv - the present value, or the lump-sum amount that a series of future payments is worth right now.

  • Arg4
    Type: System.Object

    Fv - the future value, or a cash balance you want to attain after the last payment is made. If fv is omitted, it is assumed to be 0 (the future value of a loan, for example, is 0).

  • Arg5
    Type: System.Object

    Type - the number 0 or 1 and indicates when payments are due.

Return Value

Type: System.Double

Remarks

Set type equal to

If payments are due

0 or omitted

At the end of the period

1

At the beginning of the period

See Also

Reference

WorksheetFunction Interface

WorksheetFunction Members

Microsoft.Office.Interop.Excel Namespace