ODDLPRICE in WPS on Windows: Introduction

ODDLPRICE in WPS helps calculate the price per $100 face value of a security with an odd last coupon period; 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 current tasks are available directly

About This Feature

Overview

ODDLPRICE is a financial function in WPS Spreadsheets that returns the price per $100 face value of a security with an odd last coupon period. When you type the formula, the editing area shows syntax guidance to help you enter arguments in order. The function can be used directly in a cell, combined with cross-sheet references, and nested inside other formulas. When referenced data changes, the result recalculates automatically, which is useful for bond pricing, financial analysis, and spreadsheet modeling.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office for full formula editing and calculation support
Network	Local formula calculation does not require a constant internet connection; downloading, installation, and account services require network access
Other	You need permission to open WPS Spreadsheets files, edit cells, and enter formulas

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Spreadsheets, select any cell, and type `=ODDLPRICE(` to confirm that the formula entry point and syntax guidance are available

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Provides the ODDLPRICE financial function for direct cell entry, with syntax guidance, cross-sheet references, nested calculations, and automatic recalculation.	Excel provides the ODDLPRICE function and documents that it returns the price per $100 face value of a security with an odd last coupon period, with arguments such as settlement, maturity, last_interest, rate, yld, redemption, frequency, and basis.	Google Sheets supports formulas and functions in cells, shows a function help box during editing, and supports nested functions, but the official function guidance does not show ODDLPRICE as a documented function on the referenced page.	Notion formulas work with database properties, built-ins, and functions for calculations inside databases, rather than spreadsheet-style financial functions such as ODDLPRICE.	Acrobat supports calculation rules for PDF form fields, which is useful for form totals and field interactions, rather than spreadsheet financial functions such as ODDLPRICE.
WPS Advantages	Advantage: WPS lets you enter and calculate ODDLPRICE directly in a spreadsheet cell. Distinct: It combines syntax guidance, cross-sheet references, nested formulas, and automatic recalculation in a spreadsheet workflow.	Compared with WPS: Excel also provides the same named function with detailed argument documentation for standard financial calculation scenarios.	Compared with WPS: Google officially emphasizes general formula entry, suggestions, and help boxes, but the referenced official guidance does not present ODDLPRICE as a dedicated financial function.	Compared with WPS: Notion formulas are designed for database property logic, not for spreadsheet cell-based bond pricing functions.	Compared with WPS: Adobe calculation features are centered on PDF form fields, not spreadsheet-based bond pricing formulas.
Official Source	—	ODDLPRICE function	Add formulas & functions	Formula syntax & functions	Configure form field calculations in Acrobat

Overall Conclusion
If your main task is spreadsheet-based financial calculation with ODDLPRICE, WPS and Microsoft Excel both provide a direct function path. Google, Notion, and Adobe focus more on general formulas, database formulas, or PDF form calculations in their official guidance, so WPS is a closer fit for this specific spreadsheet modeling scenario.

Use Cases

No.	Scenario	Suitable Users	Main Need	How WPS Helps
1	Bond price calculation	Finance staff	Need to calculate the price of a security with an odd last coupon period quickly	Enter ODDLPRICE in a cell and complete the calculation with the required arguments
2	Cross-sheet financial models	Analysts	Source data is spread across multiple worksheets	Use cross-sheet references to pass arguments into ODDLPRICE
3	Combined formula analysis	Advanced spreadsheet users	A single function result needs to feed into a larger formula	Nest ODDLPRICE inside a broader analysis formula
4	Dynamic result tracking	Report maintainers	Results need to update when inputs change	Use automatic recalculation to refresh results in real time
5	Formula learning and checking	New users	Argument order and input format are not yet familiar	Use syntax guidance while entering the function

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
ODDLPRICE formula entry and calculation	✅ Available	✅ Available
Basic PDF features	✅ Available	✅ Available
Cloud storage	1 GB	20 GB
Template downloads	Limited	More advanced templates and extended benefits

Source: WPS Office pricing page

Recommendations

Usage Scenario	Recommended Plan	Why
Occasional ODDLPRICE calculations or light spreadsheet work	Free	It already supports formula entry, calculation, and basic spreadsheet work
Need more cloud storage or broader office benefits	WPS Premium	Better suited to long-term, multi-device, or expanded office use

WPS membership center: Subscribe now