How to Use the PRICEMAT Function in WPS on Windows

Last updated:July 20, 2026

Use PRICEMAT through 4 indexed topics, all available without membership, to enter the function, review syntax, use cell references, and confirm result updates.

How-to Index

No.TopicMembership
11. Enter the PRICEMAT functionFree
22. Review the function syntax promptFree
33. Use cell references for parametersFree
44. Check result updatesFree

How-to Guide

1. Enter the PRICEMAT function

Entry point: Formulas tab → formula bar

  1. Open WPS Spreadsheet and select the cell where you want the result to appear.
  2. Type = in the formula bar or cell to begin the formula.
  3. Type PRICEMAT(.
  4. Continue entering the required parameters and confirm the calculation.

Success Criteria

  • The selected cell is in formula editing mode.
  • The formula starts with =PRICEMAT(.
  • You can continue entering parameters.

Tips While Using

  • The formula must begin with =.
  • Enter the function name and opening parenthesis completely.

2. Review the function syntax prompt

Entry point: Select a cell → type the function name

  1. Type =PRICEMAT( in the cell or formula bar.
  2. Watch for the syntax prompt that appears on screen.
  3. Review the parameter order and expected inputs.
  4. Continue entering the actual values.

Success Criteria

  • A PRICEMAT-related syntax prompt appears.
  • You can review parameter guidance or example information.

Tips While Using

  • If no prompt appears, check the spelling of the function name.
  • Review the parameter order before entering dates and rates.

3. Use cell references for parameters

Entry point: Formula bar → select parameter cells

  1. Prepare the issue date, settlement date, maturity date, rate, yield, and frequency in worksheet cells.
  2. Type =PRICEMAT( in the result cell.
  3. Select the corresponding cells in parameter order, or type the cell references manually.
  4. Type the closing parenthesis and press Enter.

Success Criteria

  • The formula shows cell references.
  • The cell returns a calculation result.

Tips While Using

  • Keep the parameter order consistent with the function prompt.
  • Make sure dates and numeric values are in calculable formats.

4. Check result updates

Entry point: Change referenced values → review the result cell

  1. Locate the cell that already contains PRICEMAT.
  2. Change a referenced date, rate, yield, or frequency value.
  3. Review whether the result cell updates automatically.
  4. If needed, select the formula cell again to confirm the references.

Success Criteria

  • The result changes when referenced values change.
  • The formula remains editable.

Tips While Using

  • If the result looks wrong, check for numbers stored as text.
  • After editing inputs, make sure separators and parentheses remain intact.