WPS Features
Resources
Free AI Tools
Docs Center

How to Use the FVSCHEDULE Function in WPS on Windows

Last updated:July 13, 2026

Use the FVSCHEDULE function in WPS with 3 how-to topics, all available without membership, and jump to the exact workflow from the How-to Index.

How-to Index

No.TopicMembership Requirement
11. Enter it from the Insert Function dialogFree
22. Type the formula directly in a cellFree
33. Review syntax and parameter detailsFree

How-to Guide

1. Enter it from the Insert Function dialog

Entry point: Formulas tab → Insert Function

  1. Select the cell where you want to enter the formula.
  2. Click the fx button in the formula bar, or click Insert Function on the Formulas tab.
  3. Search for FVSCHEDULE in the dialog box.
  4. Select the function and click OK.
  5. Enter each parameter in the Function Arguments dialog box.
  6. Click OK to finish.

Success Criteria

  • The selected cell now contains the FVSCHEDULE function.
  • A result is returned after the parameters are entered.
  • You can continue editing, copying, or saving the worksheet.

Tips While Using

  • Search with the English function name FVSCHEDULE.
  • Keep the parameter order consistent with the fields shown in the dialog box.

2. Type the formula directly in a cell

Entry point: Cell → Formula bar

  1. Select the target cell.
  2. Type =FVSCHEDULE(...) directly in the cell or in the formula bar.
  3. Press Enter to confirm.
  4. If you want to review syntax guidance, type =FVSCHEDULE( and then press F1.

Success Criteria

  • The cell shows a calculation result or a complete formula entry.
  • The full FVSCHEDULE formula is visible in the formula bar.
  • You can continue filling, copying, or editing the formula.

Tips While Using

  • Use English commas as parameter separators.
  • If the result looks incorrect, check whether the parameters are valid numbers or ranges.

3. Review syntax and parameter details

Entry point: Formulas tab → Insert Function

  1. Click Insert Function on the Formulas tab.
  2. Search for FVSCHEDULE.
  3. Select the function and review the syntax: FVSCHEDULE(principal, schedule).
  4. Click the help link for more details if it is available.

Success Criteria

  • You can see the function name, syntax, and parameter area.
  • You can confirm the input requirements for principal and schedule.
  • You can continue entering the formula or troubleshooting input issues.

Tips While Using

  • Reviewing syntax is useful before final entry.
  • If the worksheet already contains data, check the referenced range before returning to editing.