WPS Features
Resources
Free AI Tools
Docs Center

How to Use the PRICE Function in WPS on Windows

Last updated:July 13, 2026

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

How-to Index

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

How-to Guide

1. Insert PRICE 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 PRICE in the Insert Function dialog box.
  4. Select the function and click OK.
  5. Enter each parameter in the Function Arguments dialog box.
  6. Click OK to finish entering the function.

Success Criteria

  • The target cell now contains the PRICE function.
  • The cell returns a result, or the formula remains available for further editing.

Tips While Using

  • Keep the parameter order consistent with the function syntax.
  • Check date, rate, and frequency values before confirming the formula.

2. Type the PRICE formula directly in a cell

Entry point: Cell / formula bar

  1. Select the cell where you want to enter the formula.
  2. Type =PRICE(...) directly in the cell or in the formula bar.
  3. Press Enter to confirm.
  4. If you want to review the parameter hint, type =PRICE( and check the syntax prompt in the editing area.

Success Criteria

  • The PRICE formula has been entered in the cell.
  • After you press Enter, the result appears and the formula can still be edited from the formula bar.

Tips While Using

  • Separate parameters with English commas.
  • When filling the formula across rows, check whether relative or absolute references need adjustment.

3. Check PRICE syntax and parameter details

Entry point: Formulas tab → Insert Function

  1. Click Insert Function on the Formulas tab.
  2. Type PRICE in the search box.
  3. Review the syntax: PRICE(settlement, maturity, rate, yld, redemption, frequency, [basis]).
  4. Check the meaning of each parameter in the Function Arguments window before entering values.

Success Criteria

  • You can see the full syntax structure of PRICE.
  • You can distinguish required parameters from the optional one.

Tips While Using

  • Check the logical relationship between settlement and maturity before entering values.
  • If the result looks incorrect, return to the parameter window and review each input value.