WPS Features
Resources
Free AI Tools
Docs Center

How to Use the RATE Function in WPS on Windows

Last updated:July 13, 2026

Use the RATE function in WPS Spreadsheet through 3 how-to topics; 3 are available without membership and 0 are membership-related.

How-to Index

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

How-to Guide

1. Insert RATE from the Insert Function dialog box

Entry point: Formula 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 Formula tab.
  3. Search for RATE in the Insert Function dialog box.
  4. Select the function and click OK.
  5. Enter the required arguments in the Function Arguments dialog box.
  6. Click OK to finish inserting the function.

Success Criteria

  • The current cell contains the RATE function.
  • A calculation result is returned after the arguments are entered.
  • The formula can be edited, copied, or filled further.

Tips While Using

  • Separate arguments with English commas.
  • Check that values such as nper, pmt, and pv use the correct data type before confirming the formula.

2. Type the RATE formula directly in a cell

Entry point: worksheet cell or formula bar

  1. Select the cell where you want to enter the formula.
  2. Type =RATE(...) directly in the cell or in the formula bar.
  3. Press Enter to confirm the formula.
  4. If needed, review the syntax prompt after typing =RATE(.

Success Criteria

  • The RATE formula is entered in the selected cell.
  • Pressing Enter returns a result or keeps the formula ready for further editing.
  • The formula can be copied to other cells.

Tips While Using

  • When copying the formula across cells, check relative and absolute references.
  • If the result looks incorrect, review the argument order and the positive or negative signs used in the inputs.

3. Review RATE syntax and argument details

Entry point: Formula tab → Insert Function

  1. Click Insert Function on the Formula tab.
  2. Search for RATE.
  3. Review the syntax RATE(nper, pmt, pv, [fv], [type], [guess]).
  4. Read the argument descriptions in the function area before filling in the formula.

Success Criteria

  • The full RATE syntax is visible.
  • Required and optional arguments are identified.
  • You can return to the worksheet and continue entering or editing the formula.

Tips While Using

  • guess is optional and is used as an estimated starting value for iteration.
  • Keep the units for periods and rates consistent, such as using monthly values for both when payments are monthly.