NPER Function in ONLYOFFICE Spreadsheet Editor: Syntax, Examples and Troubleshooting

• Introduced: The original introduction release and date are not established by the official sources checked.
• Availability: Documented in the current ONLYOFFICE Spreadsheet Editor help; no final working-version endpoint is established.
• Scope: Docs and Desktop Editors release separately. The unversioned reference does not establish support in every older build or mobile client.
• Checked: October 14, 2026, against the official NPER reference. Documentation check; not a new native test.

=NPER(rate, pmt, pv, [fv], [type])

Square brackets show optional arguments; do not type the brackets into a formula.

Unlike the nper argument in PMT, the NPER function returns a period count, potentially noninteger. It is not a date function.

Signs: The vendor explains that money paid out is negative and money received is positive. Thus a loan with pv=10000 and negative payments models the borrower receiving $10,000 then making outflows. Interest must be expressed per payment period, not automatically per year. type=0 means end-of-period; type=1 means beginning-of-period.

Enter the following in a blank worksheet. Keep B2:B7 unchanged and put each result in an unused cell starting at D2. Inputs with a leading equals sign are formulas, not literal text.

Expected numerical results are shown to six decimal places. Rates are decimal fractions: 0.005 means 0.5%.

Why NPER can return a fraction

NPER solves for a continuous number of period intervals in a compound-interest equation. For fixed rate r, payment P, present value V, future value F, payment timing t, and r ≠ 0, the mathematical solution is n = LN((P×(1+r×t)−F×r)/(P×(1+r×t)+V×r))/LN(1+r), where the logarithm arguments are positive. At r=0, n=−(V+F)/P when P≠0. The expression is useful for checking expected results; it is not a guarantee about a particular installed editor’s numerical method or error messages.

A result such as 57.680136 months means 57.68 equal-payment periods mathematically. Loan servicing normally uses whole payments and an adjusted final installment; rounding NPER to 58 does not prove an additional full payment is due. For this idealized month-end schedule, 57 full $200 payments leave approximately 135.458372. One more month’s interest gives a final payment of approximately 136.135663, rather than another full $200. On a separate worksheet, the balance check is =10000*(1+0.005)^57-200*((1+0.005)^57-1)/0.005. Actual contractual rounding may change the last payment.

Loan versus goal savings

The baseline loan uses positive pv=10000, negative pmt=-200, and fv=0. For an investment goal, start pv=0, enter a negative monthly savings deposit pmt=-150 and positive target fv=10000; the sign convention matters. Set type=1 for deposits at the beginning of each period. Make every rate and time unit comparable; for a 4% nominal annual rate with monthly credits, use 4%/12 for rate and read result as months.

• PMT — calculate a fixed periodic payment.

• IPMT — return interest for a chosen payment period.

• PPMT — return principal for a chosen payment period.

• RATE — solve the periodic rate.

• PV — solve present value.

• FV — solve future value.

• Official function catalogue / how to insert formulas.

• Advanced Settings / formula languages and separators.

Examples use English function names, commas and numeric decimal rates. The function-entry guide describes the function dialog; Advanced Settings covers formula language and regional formatting. ROUND explains deliberate numeric rounding, and SUM helps build cash-flow checks.

Expected values were independently calculated from the stated financial equations and separately cross-checked. No example was executed in ONLYOFFICE. Fixed-rate models omit fees, taxes, irregular dates and contractual rounding unless those assumptions are added explicitly.