PRICEMAT in WPS on Windows FAQ

This FAQ covers 3 common question types about errors, result checking, and filling formulas across cells, plus 3 glossary terms for quick reference.

FAQ

What should I do if PRICEMAT returns an error value?

1. Check whether each parameter uses a valid calculable data type.
2. Make sure date parameters are valid dates instead of plain text.
3. Review the separators, parentheses, and parameter order in the formula.

Why does the PRICEMAT result not match what I expected?

1. Check whether settlement, maturity, issue, rate, and yld are entered correctly.
2. Review whether you need to enter basis and whether it matches your calculation method.
3. Re-enter the parameters one by one after checking the syntax.

How to use the PRICEMAT function in WPS on Windows across multiple cells?

1. Enter the PRICEMAT formula in the first cell.
2. Select that cell and drag the fill handle in the lower-right corner across the target range.
3. If you need fixed references, add $ to the related references before filling.

Glossary