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

• Introduced: The original introduction version 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. This unversioned help does not establish availability in every older build, mobile client or deployment.
• Checked: October 14, 2026, against the official function reference. Documentation check; not a new native test.

=PMT(rate, nper, pv, [fv], [type])

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

Documentation transcription warning: The current English vendor PMT page prints PMT(rate, nper, pv, [fv], [type) (missing the final ] on [type]). Its argument table clearly identifies both optional parameters, so this review supplies the corrected balanced display PMT(rate, nper, pv, [fv], [type]). This is a documentation punctuation correction, not an unverified sixth argument.

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.

Set the editor’s formula language to English and use the documented comma-separated argument style for these examples. In a fresh blank worksheet, enter the following exactly. Cells outside this table should remain empty before placing results. Format rate cells as percentages if desired; formatting changes only display, not the stored rate.

In another unused column, enter one formula from the examples at a time. For example, use D2 for the first formula, D3 for the next, and so forth. Do not overwrite B2:B13 or change the baseline values between examples. Each table formula is a complete formula ready to type, not a fragment. Where alternative rates, terms or timing appear as literals, they intentionally override only those baseline assumptions. The figures are independently calculated mathematical expectations, not observed output from ONLYOFFICE.

The expected results below were computed independently from the vendor docs; they are not claims of successful ONLYOFFICE execution. A displayed result is rounded to six decimals for readability; compare higher precision if validating workbook execution.

Formula-entry sequence: Open a blank sheet, enter the baseline table exactly, choose an unused output cell, type the leading = and the complete expression, then press Enter. The ONLYOFFICE function guide also describes the Formula tab and Shift+F3 for choosing a function. Each test should be run with the indicated argument count; commas are literal separators in the documented English configuration. Compare the result against the expected value and record any native discrepancy with exact app build and locale.

Derive the payment rather than memorize a number

If r is the per-period rate and n is number of payments, the end-of-period annuity factor is A=((1+r)^n−1)/r. For nonzero r, expected PMT is −(pv×(1+r)^n + fv)/(A×(1+r×type)). If r=0, expected PMT is −(pv+fv)/n. This identity explains why changing type from zero to one reduces the negative payment magnitude: each deposit is invested one period sooner. It is independent financial mathematics, not a native-onlyoffice formula implementation claim.

Compare fixed-rate scenarios

A borrower comparing =PMT(4%/12,60,10000) with =PMT(8%/12,60,10000) sees a higher periodic payment for the higher rate when the term and proceeds are unchanged. For a five-year example, multiply the unrounded payment by 60 to estimate total contractual payments and then compare with the $10,000 proceeds. A lender may round individual installments and adjust the final balance; that is outside the PMT calculation.

Savings interpretation

=PMT(4%/12,60,0,10000) starts with no balance, targets a positive future savings amount and returns the required negative periodic deposit. Setting type=1 assumes deposits at the beginning of each month. Neither example incorporates taxes, fees, changing returns or contributions with variable timing.

• IPMT — return interest for a chosen payment period.

• PPMT — return principal for a chosen payment period.

• NPER — solve the number of periods.

• 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.

The examples use English function names, decimal points and comma argument separators, matching the function-entry guide. Adapt notation to the installed formula-language and region settings. When moving a workbook between products, recalculate the small sample in the destination version before trusting the full model. Display precision is separate from the stored value; retain unrounded intermediate values when reconciling totals.

• ONLYOFFICE PMT function reference: purpose, syntax and argument meanings.
• Spreadsheet Editor formula entry: function catalog and English entry syntax.
• Docs release history and Desktop Editors release history: separate product timelines.

• ROUND: choose displayed calculation precision
• IF: validate a worksheet condition