NPer (MDX)

Returns a number with the number of periods for an annuity based on periodic, fixed payments and a fixed interest rate.

  • Returned Output: Numeric
  • Library: MDX \ VBA \ Financial
  • Version: 2018.00.000
  • Compatibility: Microsoft MDX Engines only


NPer( <Rate> , <Payments> , <Present Value> )

Further Help on Syntax and Examples
  • For more details on using the VBA library in MDX please click here.
  • For more details on the syntax of the VBA function please click here