PRICE in WPS on Windows: Introduction

PRICE in WPS on Windows is a financial spreadsheet function for calculating the price per 100 face value of a security that pays periodic interest; 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	Matches the number of membership-related rows in the index

About This Feature

Overview

The PRICE function in WPS Spreadsheet on Windows is used to calculate the price per 100 face value of a security that pays periodic interest. It fits bond pricing, yield analysis, and spreadsheet-based financial calculation workflows.

Core capabilities include:

Show syntax guidance when you type PRICE( so you can review required arguments quickly.
Enter the formula directly in a cell or in the formula bar and return a result immediately.
Support cross-sheet references and nested calculations, with results updating when referenced data changes.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	The latest version of WPS Office is recommended
Network	No mandatory internet connection is required for local formula calculation; downloading, installation, and account services require internet access
Other	You need to be able to open WPS Spreadsheet files and edit formulas in cells

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Spreadsheet, select a worksheet cell, and type `=PRICE(` to confirm that function guidance appears

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Use the PRICE function in WPS Spreadsheet to calculate the price of a security that pays periodic interest, with formula guidance, direct cell entry, cross-sheet references, and recalculation.	Excel provides the PRICE function and returns the price per $100 face value of a security that pays periodic interest, with documented syntax and basis options.	Google Sheets provides the PRICE function for calculating the price of a security paying periodic interest based on settlement, maturity, rate, yield, redemption, frequency, and day count convention.	Notion provides a general formula system with properties, operators, and functions for calculations, but it does not document a spreadsheet-style PRICE financial function.	Adobe Acrobat provides calculated form fields and form automation in PDF forms, which supports field-based calculations rather than spreadsheet financial functions.
WPS Advantages	Advantage: Works directly in a desktop spreadsheet workflow with cell-based formula entry, syntax prompts, and automatic recalculation for routine financial analysis.	Compared with WPS: Excel documents more argument details and error conditions for PRICE; both products support spreadsheet-based financial function workflows.	Compared with WPS: Google Sheets also supports PRICE, but it is centered more on browser-based collaboration; WPS fits local desktop spreadsheet editing more directly.	Compared with WPS: Notion formulas are designed for database properties and general calculations, not for a dedicated spreadsheet PRICE function workflow.	Compared with WPS: Adobe focuses on PDF form calculations and field automation, not on spreadsheet-based PRICE function usage.
Official Source	—	PRICE function	PRICE	Formula syntax & functions	Advanced form fields

Overall Conclusion
If your main task is pricing securities inside a spreadsheet, WPS, Excel, and Google Sheets all cover this type of financial function scenario. For Windows users who want a desktop spreadsheet path with direct cell editing, syntax prompts, and automatic recalculation, WPS provides a practical workflow for day-to-day formula work.

Use Cases

No.	Scenario	Suitable For	Core Need	How PRICE Helps
1	Bond price calculation	Finance staff	Estimate a security price from yield data quickly	Enter the PRICE function in a worksheet cell and fill in the required arguments
2	Training and practice	Students and trainers	Review arguments while entering a financial formula	Type `=PRICE(` to open syntax guidance during practice
3	Multi-sheet analysis	Data analysts	Reference values from other sheets and keep results updated	Combine PRICE with cross-sheet references and nested formulas

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
Basic use of the PRICE function	✅ Available	✅ Available
Basic spreadsheet editing	✅ Available	✅ Available
More advanced office and PDF features	Some features are limited	More advanced features and more cloud storage
Cloud storage	1 GB	20 GB

Source: WPS Office pricing page

Recommendations

Scenario	Recommended Plan	Why
Learning formulas and handling basic security price calculations	Free	The PRICE function and basic spreadsheet editing are already available
Using more advanced office features, PDF tools, or larger cloud storage	WPS Premium	Better suited for users who work across multiple document types and need expanded capabilities

WPS membership: Subscribe now