WPS Features
Resources
Free AI Tools
Docs Center

How to Use the RRI Function in WPS on Windows

Last updated:July 13, 2026

Use the RRI function in WPS with 3 how-to topics; all 3 are available without membership, so you can choose the method that fits your workflow.

How-to Index

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

How-to Guide

1. Insert the function from the Insert Function dialog

Entry: 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 RRI in the dialog box.
  4. Select the function and click OK.
  5. Enter each parameter in the Function Arguments dialog.
  6. Click OK to finish inserting the function.

Success Criteria

  • The selected cell now contains the RRI function.
  • A calculation result is returned after the parameters are completed.
  • The formula can be edited or copied to other cells.

Tips While Using

  • Enter the parameters in the order nper, pv, fv.
  • Make sure the target cell is selected before opening the dialog.

2. Type the formula directly in a cell

Entry: Cell → Formula bar

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

Success Criteria

  • The formula is entered in the cell.
  • Pressing Enter shows a result or keeps the formula ready for complete parameter input.
  • The formula remains editable in the formula bar.

Tips While Using

  • Use English commas as parameter separators.
  • If the result looks incorrect, first check whether the parameters are numeric values.

3. Check the syntax and parameter details

Entry: Formulas tab → Insert Function

  1. Click Insert Function on the Formulas tab.
  2. Type RRI in the search box.
  3. Select the function and review the syntax RRI(nper, pv, fv).
  4. Click the help link for the function if you want more details.

Success Criteria

  • The RRI function name and syntax are visible.
  • You can confirm where each parameter should be entered.
  • You can return to the worksheet and continue entering the formula.

Tips While Using

  • Reviewing the syntax first can help reduce parameter order mistakes.
  • After checking the syntax, you can switch to direct entry for faster work.