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

=PV(rate, nper, pmt, [fv], [type])

Defaults: fv=0; type=0 (end of period). Square brackets mark optional inputs; do not type them. The help page does not explicitly enumerate every invalid-input behaviour or native error code.

Rates and signed cash flows: The vendor specifically advises keeping the units of rate and nper consistent and recording money paid out with negative cash-flow signs, money received with positive signs. 6%/12 is a per-month rate for a nominal 6% annual rate with monthly periods; it is not a promise that a lender’s actual interest schedule follows this convention.

1. Open a new blank spreadsheet in ONLYOFFICE Spreadsheet Editor. Select the English formula language, or adapt the formula names/separators to the actual configured locale. Choose a blank sheet.
2. Enter these literal inputs in the stated cells in column B. For entries beginning with =, enter the formula. For negative payments, include the minus sign.
3. Put each worked formula below in a fresh cell such as D2, D3, …; do not overwrite the baseline B-column inputs. Increase displayed decimal places for precision comparisons.
4. Press Enter after each formula or use Formula → Function (the official function-insertion guide describes the Insert Function dialog and Shift+F3). Compare with expected outputs, recording the exact Desktop or Docs/web build and locale when native testing becomes available.

Example scope: Only the formula labeled as using B-cells depends on the preceding baseline. The other examples use explicit literal values and may be entered in any otherwise blank output cell. Formula examples use the vendor’s English, comma-separated syntax; other locale settings may require adaptation, which was not natively tested.

Independent expected results (rounded to six decimal places (half-up)) are provided for every row. These are not screenshots, measured native ONLYOFFICE outputs, or claims of product compatibility in historical builds.

Result interpretation: The answer is a signed monetary amount in the same unit as the payment and balance inputs. Its sign follows the cash-flow viewpoint, not a percentage format.

Loan affordability versus annuity value

=PV(6%/12,60,-200) estimates how much can be received today against 60 monthly payments of $200 under a constant 6% nominal annual discount rate. That is the mathematical amount financed; it excludes lender fees, tax treatments and credit decisions. Use =PMT(6%/12,60,PV(6%/12,60,-200)) to return the negative monthly payment as an independent algebraic cross-check (subject to display rounding).

One-time future amount and viewpoint

=PV(6%/12,60,0,-10000) uses a future outflow of 10,000 and returns the positive offsetting amount today, expected 7413.721962. From a saver’s viewpoint, a future receipt is positive: =PV(6%/12,60,0,10000) then returns −7413.721962, the initial investment outflow. Either convention can express the same discounted magnitude, but the labels and signs must be consistent.

At zero interest, the mathematical model reduces to a simple sum: =PV(0,12,-100) has expected value 1200. A zero-rate example is a limiting cash-flow model, not evidence of every invalid-input response.

Timing sensitivity

For the same 60 payments, type=1 places them one period earlier. Their mathematical present value is larger than end-of-period payments. It is not a different interest rate.

Financial identity for audit

For nonzero periodic r, put A=((1+r)^n−1)/r. Expected PV=−[fv+pmt·A·(1+r·type)]/(1+r)^n; at zero rate PV=−(fv+n·pmt). Check sign conventions before applying the expression to debt or investment decisions.

Limits of the model: Annuity present values require a constant rate, constant payment and consistent cash-flow perspective; published examples are mathematical expectations. The official source is about a calculation function rather than product-specific financial advice. Changing interest rates, fees, taxes, extra or skipped payments, compounding conventions, day-count conventions, and transaction timing may produce different real-world results.

FV advances signed payments to a future date. PMT finds the constant payment that corresponds to a known PV; NPV handles discrete cash-flow arrays. See the vendor’s references rather than assuming identical behaviour in other spreadsheet products:

• FV — official ONLYOFFICE financial-function reference.
• PMT — official ONLYOFFICE financial-function reference.
• NPER — official ONLYOFFICE financial-function reference.
• RATE — official ONLYOFFICE financial-function reference.
• NPV — official ONLYOFFICE financial-function reference.

Also consult the ONLYOFFICE Function catalogue and formula-entry instructions and Spreadsheet Editor advanced settings.

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 PV 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