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

Unlike FV, which models a fixed rate and can include regular payments, FVSCHEDULE compounds one principal through a varying list of rates. Each schedule element is a per-period decimal (5% means 0.05). The official page explicitly says that empty schedule cells are treated as rate zero; this is NOT the same as silently omitting those periods from a separately reported period count.

=FVSCHEDULE(principal, schedule)

All listed arguments are required; the official reference does not specify an omitted-argument default. Enter all parameters in the order shown. Do not type the argument placeholders literally.

Documented vendor-specific note: The official FVSCHEDULE notes permit numeric rates and empty schedule cells, interpreting the empty entries as zero. There is no vendor statement here establishing text coercion, date handling, or a specific error value for invalid entries.

Independent mathematical model: principal × (1 + r₁) × (1 + r₂) × … × (1 + rₙ), with a blank rate interpreted mathematically as 0. This is an explanatory calculation model and is not an assertion about native error handling.

1. Start a blank workbook in ONLYOFFICE Spreadsheet Editor and select an empty sheet. Use English formula names for the displayed examples.
2. Enter the following input cells exactly. Enter amounts and period counts as numbers; enter rate schedules as numeric percentages where specified.
3. Enter the first formula in the worked-example table into a blank output cell, such as H2, unless the setup names a particular output cell. Avoid overwriting the input ranges.
4. Press Enter. Increase displayed precision to at least six decimal places. Compare with the independently calculated expected result.
5. For the remaining rows, place each formula in a fresh blank output cell (H3, H4, and so on). Cells/ranges in the sample setup remain fixed unless an example explicitly uses different literal arguments.

Baseline interpretation: =FVSCHEDULE(B8,B2:B6) computes five successive changes: $1,000 × 1.02 × 1.03 × 1.04 × 1 × 0.99. B5 is deliberately blank to test the precise documented empty-cell rule.

The expected result uses a decimal number with six digits after the decimal point (half-up rounding). Results are mathematical expectations from a 60-digit Decimal calculation checked with a separate floating-point implementation; no formula was executed inside ONLYOFFICE.

Build a variable-rate investment dashboard

Put period names in column A beside the rate cells in B2:B6. Keep the principal in B8; calculate future value in H2 with =FVSCHEDULE(B8,B2:B6). For a pessimistic/optimistic comparison, replace the schedule with alternative input columns while keeping the principal fixed. Record the assumption that each row represents exactly one period. Rates for calendar years and months must not be mixed without converting periods.

Compare two paths with the same average

5% then -5% does not cancel: 1.05 × 0.95 = 0.9975. The arithmetic mean is zero but the two-period compounded outcome is a loss of 0.25%. Use actual compound products, not average-rate multiplication. A negative rate -100% mathematically reduces the investment to zero; how the native program reports out-of-range inputs is untested.

Scale the investment without changing the rate path

For a common schedule, doubling principal doubles the final value. Verify this invariant by comparing =FVSCHEDULE(1000,B2:B6) to =FVSCHEDULE(2000,B2:B6); it is a useful audit of accidental absolute vs percentage entries.

Relate FVSCHEDULE to FV without conflating them

When every schedule entry is identical, the mathematical total is principal × (1+rate)^periods. The separate ONLYOFFICE FV reference describes a periodic-payment model and is not an alias for FVSCHEDULE. Do not add deposits to the rate schedule; they are separate cash flows.

Additional validation and edge-case checklist

• Check that B5 is genuinely empty, not a formula returning "" (this distinction has not been natively checked).
• Test that =FVSCHEDULE(1000,D2:D6) preserves 1000 with a five-zero schedule.
• Replace one rate with a strongly negative value only in a disposable workbook; do not assign a guessed native error.

Error handling: The vendor reference does not list every invalid-input result. Diagnose an actual error using the entered values and installed build rather than importing an error rule from another spreadsheet.

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