WPS Features
Resources
Free AI Tools
Docs Center

How to Use the ISPMT Function in WPS on Windows

Last updated:July 13, 2026

Use the ISPMT function in WPS with 3 how-to topics on Windows; all 3 are available without membership and 0 are membership-related.

How-to Index

No.TopicMembership Requirement
11. Insert ISPMT from the Insert Function dialog boxFree
22. Type the ISPMT formula directly in a cellFree
33. Review ISPMT syntax and argument detailsFree

How-to Guide

1. Insert ISPMT from the Insert Function dialog box

Entry point: Formulas tab → Insert Function, or the fx button in the formula bar

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

Success Criteria

  • The current cell contains the ISPMT function.
  • A calculation result appears after the arguments are entered.
  • The formula can be edited, copied, or filled to other cells.

Tips While Using

  • Keep the argument order consistent with the function syntax.
  • Use numbers or valid cell references for each argument.

2. Type the ISPMT formula directly in a cell

Entry point: worksheet cell or formula bar

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

Success Criteria

  • The cell displays the formula result.
  • The full ISPMT formula is visible in the formula bar.
  • The formula can be copied to other cells.

Tips While Using

  • Separate arguments with English commas.
  • Make sure referenced cells contain valid numeric values.

3. Review ISPMT syntax and argument details

Entry point: Formulas tab → Insert Function

  1. Click Insert Function on the Formulas tab.
  2. Type ISPMT in the search box.
  3. Select the function and review the syntax: ISPMT(rate, per, nper, pv).
  4. Open the related help link if you want more details about the function.

Success Criteria

  • You can see the full ISPMT syntax.
  • You have confirmed the argument names and order.
  • You can continue entering or editing the formula with the syntax reference.

Tips While Using

  • Check the argument order carefully when reviewing the syntax.
  • After editing an existing formula, confirm that the result still matches your expected calculation.