Formualizer Docs
ReferenceFunctionsFinancial Functions

NPER

NPER: Calculates the number of periods needed to satisfy a cash-flow target.

Summary

Use this to solve term length when periodic rate, payment, and value constraints are known.

Remarks

  • rate is the interest rate per period.
  • Cash-flow sign convention: at least one of pmt, pv, or fv should usually have opposite sign.
  • type = 0 means payments at period end; type != 0 means period start.
  • Returns #NUM! when inputs imply no finite solution (for example, invalid logarithm domain).
  • Returns #NUM! when both rate = 0 and pmt = 0.

Examples

Example
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
null
Example
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
null

FAQ

Why does NPER return #NUM! for some sign combinations?

If the logarithm domain is non-positive (or rate=0 with pmt=0), there is no finite solution and #NUM! is returned.

Runtime metadata

Category

Financial

Signature

NPER(arg1: Number, arg2: Number, arg3: Number, arg4: Number, arg5…: Number)

Arity

min 3, max variadic

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2

Number · Scalar · coercion NumberLenientText

arg3

Number · Scalar · coercion NumberLenientText

arg4

Number · Scalar · coercion NumberLenientText

arg5

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

crates/formualizer-eval/src/builtins/financial/tvm.rs

NOMINAL

Converts an effective annual rate into a nominal annual rate.

NPV

NPV: Calculates net present value for equally spaced cash flows.

On this page

SummaryRemarksExamplesRelated functionsFAQWhy does NPER return #NUM! for some sign combinations?Runtime metadata