Common questions about the PRICE function usually involve parameter errors, unexpected results, and filling formulas across cells; this FAQ includes 3 common questions and a short glossary.
FAQ
What should I check if the PRICE function returns an error?
- Check whether each parameter is a valid number or date.
- Make sure the parameters are separated with English commas.
- Open the function parameter window again and review settlement, maturity, rate, yld, redemption, frequency, and basis one by one.
Why does the PRICE result look different from what I expected?
- Confirm that the settlement date and maturity date are entered correctly.
- Check whether the coupon rate, yield, and redemption value use consistent units.
- If needed, compare the formula with a known sample set to identify which parameter affects the result.
How can I use the PRICE function in multiple cells?
- Enter the full PRICE formula in the first cell.
- Drag the fill handle down, or copy and paste the formula into the target range.
- Check whether the copied formula needs locked references, and use $ where necessary.
Glossary
| Term | Definition |
|---|---|
| PRICE | A financial function in WPS Spreadsheet that returns the price of a security that pays periodic interest. |
| settlement | The settlement date parameter for the security transaction. |
| maturity | The maturity date parameter when the principal is due. |
| basis | The day count basis parameter used for date calculation. |