PRICEMAT in WPS on Windows FAQ

Last updated:July 20, 2026

Common PRICEMAT questions usually involve formula entry, parameter understanding, and result checking; this section includes 4 practical answers and a 4-term glossary.

FAQ

What should I do if PRICEMAT returns an error?

  1. Check whether the formula starts with =.
  2. Confirm that the function name is spelled PRICEMAT.
  3. Review the parentheses, separators, and number of parameters.
  4. Re-enter the parameters with the syntax prompt as a guide.

How can I view the PRICEMAT parameter guide?

  1. Select the target cell.
  2. Type =PRICEMAT(.
  3. Review the syntax prompt that appears.
  4. Confirm the parameter order before continuing.

Why does the calculation result look incorrect?

  1. Check whether the referenced dates and values are in valid calculable formats.
  2. Confirm that the rate, yield, and frequency are entered in the correct positions.
  3. Make sure text values are not being used where numbers are required.
  4. Change an input value and review whether the result updates as expected.

Can PRICEMAT work with linked worksheet cells?

  1. Put dates, rates, and frequency values in separate cells first.
  2. Reference those cells inside the PRICEMAT formula.
  3. Press Enter to complete the calculation.
  4. Update the parameter cells later to refresh the result.

Glossary

TermDefinition
PRICEMATA financial function in WPS Spreadsheet that calculates the price of a security on the settlement date.
Syntax promptOn-screen guidance that shows the parameter structure or examples while you type a function.
Cell referenceA worksheet address used in a formula instead of a fixed value so the result can update dynamically.
YieldA key pricing input that affects the value returned by PRICEMAT.