ODDFRRICE in WPS on Windows: Introduction

WPS ODDFRRICE is a financial function in WPS AirSheet for calculating accrued interest per $100 face value for a security with an odd first period; it includes 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

ODDFRRICE is a built-in function in WPS AirSheet for bond, note, and other fixed-income scenarios that involve an odd first coupon period. After you enter the settlement date, maturity date, issue date, first coupon date, coupon rate, yield, and day count basis, the function returns accrued interest per $100 face value in a worksheet cell.

Core tasks include:

Enter the ODDFRRICE function directly in a worksheet cell and complete the calculation.
Use formula prompts to check parameter order and parameter count.
Recalculate results automatically after source data changes for ongoing spreadsheet analysis.

This function is useful for fixed-income analysis, financial modeling, and spreadsheet training. It helps reduce manual calculation steps and lowers the chance of parameter entry errors. In WPS Office on Windows, it fits naturally into a spreadsheet workflow for financial formulas and linked calculations.

System Requirements

Item	Requirement
OS	A Windows device that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office
Network	No mandatory internet connection is required for local formula calculation; internet access is needed for download, installation, and account-related services
Other	You need an editable spreadsheet file and access to the formula bar

Download & Installation

Item	Details
Official Download	WPS Office Free Download
Installation Method	Download the Windows installer and complete setup with the installation wizard
Post-install Check	Open WPS Sheets, create or open a worksheet, and type `=ODDFRRICE(` in a cell to check whether the function prompt appears

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	ODDFRRICE can be entered directly in WPS AirSheet to calculate accrued interest for a security with an odd first period, with cell-based formulas and recalculation in the worksheet grid.	Microsoft Word supports formulas in table cells and can update formula results, but the official page describes document-table calculations rather than spreadsheet financial functions for securities.	The official Google Docs product page focuses on online document creation, collaboration, templates, and smart content features, and does not describe spreadsheet-style security functions in Docs.	Notion formulas can perform calculations with database properties, built-ins, and functions, which suits structured database logic rather than a traditional spreadsheet grid for security formulas.	Adobe Acrobat supports calculation fields in PDF forms, which is useful for form totals and field interactions, but the official help page does not describe spreadsheet security functions.
WPS Advantages	Advantage: You can calculate ODDFRRICE directly in worksheet cells. Distinct: It is better aligned with spreadsheet-based financial modeling and linked formula workflows.	Compared with WPS: Word formulas are centered on document tables and basic calculations, so the workflow is less aligned with financial spreadsheet modeling.	Compared with WPS: Google Docs emphasizes document collaboration instead of worksheet-based financial function entry.	Compared with WPS: Notion formulas depend on database properties and formula fields, so the experience is closer to data management than cell-by-cell financial modeling.	Compared with WPS: Acrobat calculations are designed for PDF form fields rather than spreadsheet analysis of security functions.
Official Source	—	Word table formulas	Google Docs product page	Notion formulas	Acrobat form field calculations

Overall Conclusion

If your main task is entering financial formulas in a worksheet, linking parameters, and recalculating results, WPS is more closely aligned with a spreadsheet workflow. The other products also provide calculation features, but their official documentation focuses on document tables, database properties, or PDF form fields rather than a function like ODDFRRICE in a spreadsheet environment.

Use Cases

#	Scenario	Target Users	Core Pain Point	Solution
1	Bond interest estimation	Finance staff	Manual calculation for an odd first period is time-consuming	Use ODDFRRICE to return accrued interest per $100 face value directly
2	Investment model building	Researchers and analysts	Multiple parameter sets need repeated testing	Combine ODDFRRICE with cell references for repeated recalculation
3	Training and teaching	Teachers and students	It is hard to demonstrate parameter relationships quickly	Enter the function in a worksheet and review prompts and results step by step
4	Template-based reporting	Office users	Fixed-format reports need repeated updates	Preset the formula in a template and update parameters as needed
5	Data review	Auditors and reviewers	It is difficult to trace how a result was produced	Check the formula structure and referenced cells in the formula bar

Membership & Benefits

Free vs WPS Premium

Feature	Free User	WPS Member
Basic spreadsheet functions	Available for common spreadsheet functions	Available
Basic PDF features	Includes basic PDF features	Includes more PDF tools
Cloud storage	1 GB of cloud space	20 GB of cloud space
Template downloads	Limited template downloads	More template benefits
AI tools	Some features are available with limits	More AI features and higher usage allowances

Source: WPS Office pricing page

Recommendations

Use Case	Recommended Plan	Reason
Occasional use of financial formulas and everyday spreadsheet editing	Free	It already supports ODDFRRICE entry, calculation, and regular spreadsheet work
Need more cloud storage, templates, or broader office features	WPS Member	It is more suitable for long-term work, cross-device use, and additional feature needs

WPS membership center: Subscribe now