DOLLARFR in WPS on Windows: Introduction

DOLLARFR in WPS on Windows is a built-in financial function for converting decimal prices into fractional prices; this guide covers 4 core tasks, with 4 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	4	Matches the number of rows in the How-to Index
Available without membership	4	Matches the number of Free rows in the How-to Index
Membership-related items	0	Matches the number of membership-related rows in the How-to Index
Version limit	None	Available in WPS Spreadsheet on Windows

About This Feature

Overview

DOLLARFR is a built-in financial function in WPS Spreadsheet on Windows. It converts a decimal price into a fractional price format, which is useful for securities pricing, finance worksheets, and spreadsheet analysis.

Core tasks include:

Enter the DOLLARFR function for quick financial conversion.
Set the denominator correctly for different fractional quote formats.
Use cell references for repeated calculations across rows.
Check recalculated results after source data changes.

Common use cases include securities pricing, finance worksheets, classroom demonstrations, and formula practice. It helps reduce manual conversion work and keeps results updated when source values change.

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
Network	No mandatory internet connection is required for local spreadsheet formulas; internet access is needed for download, installation, and account-related actions
Other	You need to be able to open or create a WPS Spreadsheet file

Download & Installation

Item	Details
Official download	WPS Office Free Download
Post-install check	Open WPS Office, create or open a spreadsheet, and type `=DOLLARFR(` in the formula bar to check whether function hints appear

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	WPS Spreadsheet supports DOLLARFR input, parameter entry, cell references, and automatic recalculation for fractional price conversion in spreadsheets.	Excel officially provides the DOLLARFR function for converting decimal dollar prices into fractional dollar prices, with syntax and error behavior documented.	Google Sheets lists DOLLARFR in its official function list for converting a decimal price into a decimal fraction.	Notion provides database formulas and functions for numeric and logical calculations, but it is not a cell-based spreadsheet and does not document a DOLLARFR function.	Adobe Acrobat Sign provides calculated fields that update form values dynamically, but this is form calculation rather than a spreadsheet function system and does not document DOLLARFR.
WPS Advantages	Advantage: DOLLARFR can be entered directly in WPS Spreadsheet cells and the formula bar, which fits spreadsheet-based financial conversion and fill-down workflows on Windows.	Compared with WPS: Excel also offers the same named function with similar syntax.	Compared with WPS: Google Sheets also supports DOLLARFR, while the official entry is presented through a broader function list.	Compared with WPS: Notion formulas are designed for database properties rather than cell-by-cell spreadsheet financial functions such as DOLLARFR.	Compared with WPS: Adobe focuses on form field calculations instead of spreadsheet formula entry and repeated cell calculations.
Official Source	—	Excel DOLLARFR function	Google Sheets function list	Notion formula syntax	Adobe calculated fields

Overall Conclusion

For spreadsheet-based fractional price conversion, WPS, Excel, and Google Sheets all provide direct formula support. Compared with Notion and Adobe, WPS is a closer fit for cell-based formula entry, references, and recalculation in spreadsheet workflows.

Use Cases

No.	Scenario	Suitable for	Main challenge	How it helps
1	Securities price conversion	Finance staff	Decimal prices need to be shown in fractional form	Use DOLLARFR in a cell to convert the value
2	Batch worksheet calculation	Data analysts	Many rows need the same conversion pattern	Use cell references and fill the formula down
3	Formula teaching demo	Teachers and students	The function syntax needs to be demonstrated clearly	Enter the function and review the syntax hint
4	Report review	Office users	Results need to stay updated after data changes	Use spreadsheet recalculation to keep results aligned
5	Template building	Template maintainers	Reusable finance formulas need to be preset	Add DOLLARFR formulas to spreadsheet templates

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Writer, Spreadsheet, and Presentation basics	✅ Available	✅ Available
Basic use of the DOLLARFR function	✅ Available	✅ Available
Basic PDF features	✅ Available	✅ Available
More advanced PDF, AI, and extended tools	Limited or partial access	Broader access
Cloud storage	1 GB	Higher-capacity plans available

Source: WPS Office pricing page

Recommendations

Scenario	Recommended plan	Why
You mainly need spreadsheet functions such as DOLLARFR	Free plan	Basic spreadsheet and formula features are enough for everyday calculation
You also need more PDF, AI, or sharing features	WPS Premium	Better suited to users who need broader office capabilities and more quotas

WPS membership page: Subscribe now