DOLLARDE in WPS on Windows: Introduction

DOLLARDE in WPS on Windows converts a dollar price expressed as a fraction into a decimal value; 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 DOLLARDE function in WPS Sheets is a financial formula that converts a dollar price expressed as a fraction into a decimal value, which is useful for follow-up calculations, comparisons, and data cleanup.

Core capabilities include:

Enter the DOLLARDE function and view parameter hints for faster formula input.
Convert a fractional dollar quotation into a decimal result by using the denominator argument.
Return the result directly in a cell so it can be used in other spreadsheet formulas.

This function is useful for securities pricing, financial worksheets, and standardizing historical quotations.

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 entry and calculation; internet access is needed for download and installation
Other	You need an editable spreadsheet file and a cell where formulas can be entered

Download & Installation

Item	Details
Official Download	WPS Office Free Download
Post-install Check	Launch WPS Sheets, open any worksheet, and type `=DOLLARDE(` in a cell to check whether the function hint appears

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Supports `DOLLARDE(fractional_dollar, fraction)` in WPS Sheets to convert a fractional dollar quotation into a decimal value.	Excel provides the DOLLARDE function to convert a dollar price expressed as an integer and fraction into a decimal number, with syntax and error rules.	Google Sheets provides the DOLLARDE function to convert a price quotation given as a decimal fraction into a decimal value, with syntax and examples.	Notion provides a formula language with operators and functions for database properties, but it does not document a DOLLARDE-equivalent function for securities quotation conversion.	Adobe Acrobat supports calculations in PDF form fields, but its official form guidance focuses on form calculations rather than spreadsheet functions such as DOLLARDE.
WPS Advantages	Advantage: You can enter the function directly in a spreadsheet cell and continue using the result in other formulas. Distinct: It fits worksheet-based financial conversion tasks on Windows.	Compared with WPS: Excel also offers a direct DOLLARDE function and is suitable for Microsoft 365 spreadsheet workflows.	Compared with WPS: Google Sheets also supports DOLLARDE, with a stronger focus on browser-based collaboration.	Compared with WPS: Notion formulas are designed for database properties rather than spreadsheet-style financial function names and syntax.	Compared with WPS: Adobe calculation features are centered on PDF forms, so they are less aligned with routine spreadsheet formula entry.
Official Source	—	DOLLARDE function	DOLLARDE	Formula syntax and functions	Advanced form fields

Overall Conclusion
If you need to convert fractional dollar quotations into decimal values in a spreadsheet, WPS, Microsoft Excel, and Google Sheets all cover this type of formula workflow. WPS is a direct fit for worksheet-based entry and follow-up calculations, while Notion and Adobe are better suited to database formulas or PDF form scenarios.

Use Cases

#	Scenario	Target Users	Core Pain Point	Solution
1	Securities quotation conversion	Finance staff	Fractional quotations are hard to compare directly	Use DOLLARDE to convert them into decimal values
2	Historical data cleanup	Data specialists	Different quotation formats are hard to standardize	Enter DOLLARDE in a helper column for batch conversion
3	Follow-up formula calculation	Spreadsheet analysts	Fractional quotations are hard to reuse in later formulas	Convert with DOLLARDE first, then use the result in other formulas

Membership & Benefits

Free vs WPS Premium

Feature	Free User	WPS Member
Basic spreadsheet formula entry	✅	✅
Basic spreadsheet editing	✅	✅
More advanced office and value-added features	Available within the scope shown on the pricing page	Available according to the membership benefits shown on the pricing page

Source: WPS Office pricing page

Recommendations

Use Case	Recommended Plan	Reason
Everyday formula learning and basic conversion	Free version	Basic DOLLARDE entry and calculation are enough for common spreadsheet tasks
Broader office needs beyond basic formulas	WPS Premium	Suitable if you also need more advanced tools, expanded benefits, or a broader office feature set

WPS membership center: Subscribe now