DOLLARDE in WPS Spreadsheet: Decode Sixteenth-Based Price Notation
Decode a price such as 2.08 with denominator 16 into 2.5, distinguish encoded numerator digits from decimal value and calculate quote differences correctly.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
DOLLARDE converts denominator-based price notation into an ordinary decimal value. With denominator 16, the quotation 2.08 means 2 plus 8/16, so its decimal value is 2.5. The digits after the decimal point encode a numerator; they are not already a decimal fraction of the whole amount.
The WPS lesson sometimes calls this “hexadecimal.” Its own equation and screenshot instead describe fractional quotation notation: 1.02 with denominator 16 represents 1 + 2/16 = 1.125. Do not interpret the input as a general hexadecimal numeral or expect the function to parse letter digits. Official explanation and walkthrough
Syntax and bounded input convention
=DOLLARDE(fractional_dollar, fraction)
Both arguments are required. The first supplies the encoded quotation and the second its denominator. This guide’s calculations use positive quotations with a denominator of 16 and a two-digit numerator field. Other denominators, negative quotations, coercion and invalid-input boundaries are outside these original controls.
For the chosen convention, write a quotation as w.nn, with whole part w and numerator n from 0 through 15. The independent conversion is w + n/16. In particular, 2.08 encodes eight sixteenths, whereas an ordinary decimal 2.08 represents eight hundredths. The same printed digits have different meanings until the convention is known.
Enter and decode a small quotation table
Enter the following values numerically:
| Cell | Encoded quotation | Cell | Denominator |
|---|---|---|---|
| A2 | 2.08 | B2 | 16 |
| A3 | 3.04 | B3 | 16 |
| A4 | 4.12 | B4 | 16 |
- Enter
=DOLLARDE(A2,B2)in C2. The independent expectation is 2.5. - Fill down to C3 and C4. The expectations are 3.25 and 4.75.
- Label A as encoded quotation and C as decimal value. Keep the denominator beside the original input so that its meaning survives copying or export.
Using two decimal places to display the quotation can help show its numerator field. That display choice does not perform the conversion and does not change the stored number.
Independent controls
| Formula | Interpretation | Expected decimal value |
|---|---|---|
=DOLLARDE(2.08,16) |
2 + 8/16 | 2.5 |
=DOLLARDE(3.04,16) |
3 + 4/16 | 3.25 |
=DOLLARDE(4.12,16) |
4 + 12/16 | 4.75 |
=DOLLARDE(5.01,16) |
5 + 1/16 | 5.0625 |
=DOLLARDE(7.15,16) |
7 + 15/16 | 7.9375 |
These are exact rational calculations for the chosen notation, not observed application outputs. The vendor’s published 1.02→1.125 demonstration corroborates the convention without establishing every possible denominator rule.
Practical case: compare two quotations
Suppose two fictional quotations are 2.04 and 2.12, both in sixteenths. Subtracting their encoded numbers gives 0.08, but that is not their decimal-value difference. Decode first:
=DOLLARDE(2.12,16)-DOLLARDE(2.04,16)
The first value is 2.75 and the second 2.25, so the difference is 0.5. Equivalently, the numerator difference is 8 and 8/16=0.5. This is arithmetic education, not a recommendation to transact in a financial product.
The same principle applies before averaging or multiplying quotations by quantities: calculations should operate on the decoded value unless the chosen calculation explicitly handles the quotation convention. Keeping the input and converted value in separate columns makes that choice auditable.
Limits and troubleshooting
Check the denominator with the source of the quotation; the digits alone cannot establish it. This guide does not generalize the two-digit rule to arbitrary denominators, nor establish fractional-denominator truncation or exact error behavior through execution. The lesson contains additional error remarks, but the original examples remain within valid positive denominator 16 inputs.
DOLLARDE performs notation conversion, not currency conversion, exchange-rate retrieval or text formatting. ROUND changes numeric precision; TEXT produces formatted text. Those are different operations. Use ordinary decimal values for subsequent arithmetic and preserve the original quotation when its provenance matters.
Availability and evidence scope
The official WPS lesson is dated 2020-09-02 and explicitly applies to WPS Office for Windows Personal. Its numeric build is unspecified. This is a documented-by date, not a function introduction date; the first supported version and last functioning build remain unknown. The lesson does not establish Linux or other-edition parity, nor a retirement or deprecation history.
The complete text and vendor walkthrough were inspected on October 18, 2026. The original examples in this guide are documentation-derived and independently calculated, not executed in WPS or another spreadsheet engine. Vendor walkthrough observations are identified separately and are not native tests of these examples.