PRICEMAT is a financial function in WPS Sheets that returns the price of a security that pays interest at maturity; this guide covers 3 core tasks, with 3 available without membership and 0 membership-related items.
At a Glance
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 3 | Matches the number of rows in the How-to Index |
| Available without membership | 3 | Matches the number of Free rows in the index |
| Membership-related items | 0 | All topics in this guide are available directly |
About This Feature
Overview
PRICEMAT is a financial function in WPS Sheets on Windows that returns the price of a security that pays interest at maturity based on the expected yield. You can use it through the Insert Function dialog, type the formula directly in a cell, or review the syntax and parameter details before entering values in your spreadsheet.
Core tasks include:
- Entering PRICEMAT through the function wizard when you want to fill in parameters one by one.
- Typing the formula directly in a cell or in the formula bar when you already know the syntax.
- Reviewing the syntax and parameter details to check settlement, maturity, issue, rate, yld, and basis.
This function is useful for security price calculations, finance worksheet entry, and spreadsheet formula learning.
System Requirements
| Item | Requirement |
|---|---|
| OS | A Windows device that can run WPS Office |
| App version | It is recommended to use the latest version of WPS Office |
| Network | No required internet connection for local formula entry; internet access is needed for the download page or online help |
| Other | WPS Sheets should be installed, and your worksheet should include dates, rates, yields, or related financial inputs |
Download & Installation
| Item | Details |
|---|---|
| Official Download | WPS Office Free Download |
| Installation | Download and install WPS Office, then open WPS Sheets to use spreadsheet functions |
| Post-install Check | Open WPS Sheets and confirm that the Insert Function entry is available on the Formulas tab |
Source: WPS download page
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | WPS Sheets provides the PRICEMAT function for calculating the price of a security that pays interest at maturity, and it can be entered through Insert Function or by typing the formula directly. | Microsoft Excel provides the PRICEMAT function and describes it as returning the price per $100 face value of a security that pays interest at maturity. | Google Sheets provides the PRICEMAT function with settlement, maturity, issue, rate, yield, and an optional day count convention. | Notion formulas can calculate values with database properties, built-ins, and functions, but they are not a spreadsheet financial function library. | Adobe Acrobat supports calculated form fields in PDF forms, which are designed for form logic rather than spreadsheet financial functions. |
| WPS Advantages | Advantage: WPS supports the same spreadsheet-style PRICEMAT workflow described in this guide, including function-wizard entry and direct formula entry in cells. | Compared with WPS: Excel also offers a direct PRICEMAT function for workbook-based financial calculations. | Compared with WPS: Google Sheets also offers PRICEMAT, mainly in a browser-based spreadsheet workflow. | Compared with WPS: Notion is better suited to database property calculations than to direct spreadsheet use of PRICEMAT. | Compared with WPS: Acrobat is better suited to PDF form calculations than to entering security-pricing formulas in a spreadsheet grid. |
| Official Source | — | PRICEMAT function | PRICEMAT | Intro to formulas | Configure form field calculations in Acrobat |
Overall Conclusion
If your main goal is to enter and calculate PRICEMAT in a spreadsheet, WPS, Microsoft Excel, and Google Sheets are the most directly comparable options. Notion and Adobe Acrobat focus on database formulas or PDF form calculations, so their use cases are different from spreadsheet-based financial functions.
Use Cases
| # | Scenario | Target Users | Core Pain Point | Solution |
|---|---|---|---|---|
| 1 | Security price calculation | Finance and analysis users | Need to calculate a security price from expected yield more efficiently | Use the PRICEMAT function in a worksheet |
| 2 | Repeated template entry | Spreadsheet maintainers | Need to enter the same type of financial formula in recurring templates | Type =PRICEMAT(...) directly in cells |
| 3 | Formula learning and checking | New users | Need help understanding parameter order and meaning | Use Insert Function and review the parameter details |
Membership & Benefits
Free vs WPS Premium
| Feature | Free User | WPS Member |
|---|---|---|
| Basic spreadsheet functions | ✅ Available | ✅ Available |
| Cloud storage | 1 GB | 20 GB |
| Template downloads | Limited | More advanced templates and added benefits |
| PDF and advanced tools | Basic features | More advanced features |
Source: WPS Office pricing page
Recommendations
| Use Case | Recommended Plan | Reason |
|---|---|---|
| Daily formula entry and learning | Free | Basic PRICEMAT use is available directly |
| More cloud storage and broader office tools | WPS Member | Suitable when you also need more templates, PDF tools, and cloud-related features |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page