DOLLARFR in WPS Spreadsheet: Encode Decimal Values as Sixteenths

=DOLLARFR(decimal_dollar, fraction)

The arguments supply the decimal value and the denominator. The original controls here use positive values exactly representable in sixteenths, with denominator 16. The WPS walkthrough’s 1.125→1.02 example supports the same convention: 0.125×16=2, written in a two-digit numerator field. Its table also shows a denominator 32 example, but no arbitrary-denominator or rounding algorithm is inferred here. Official WPS lesson

For the chosen inputs, split the value into a whole part w and fractional remainder f. Calculate n=16f, an integer from 0 through 15, then encode w+n/100. The 100 scales the two-digit field; it is not the quotation denominator.

Enter 2.5, 3.25 and 4.75 in A2:A4, and 16 in each cell B2:B4. Then:

1. Enter =DOLLARFR(A2,B2) in C2. Expect 2.08 under the documented convention.
2. Fill down. C3 represents 3 + 4/16 as 3.04; C4 represents 4 + 12/16 as 4.12.
3. Keep column A as the numeric-value column for totals and comparisons. Label column C as quotation in sixteenths.

A cell’s display may omit insignificant trailing zeros. Showing two decimal places can make the numerator field easier to read, but display formatting does not change which value the field represents. The function’s output is numeric notation; no specific font or locale-dependent rendering has been tested here.

No rounding of a fractional numerator is necessary in these controls. A value that is not an exact sixteenth requires a separately established representation and precision policy; these examples do not promise how WPS handles that situation.

Two fictional decimal values are 2.25 and 2.75. Their mean is (2.25+2.75)/2=2.5. To present that value in sixteenths:

=DOLLARFR((2.25+2.75)/2,16)

The expected quotation is 2.08. The underlying mean remains 2.5. A reader should be able to find both the decimal calculation and the notation convention, rather than having to guess from the displayed digits.

For a second check, 0.5 of a unit corresponds to 8 sixteenths, and decoding the resulting 2.08 convention gives 2+8/16=2.5 again. This is an independent mathematical round trip for exactly representable values, not a claim of universal floating-point round-trip identity.

Do not add encoded quotations as though their fractional fields were hundredths. Do not use DOLLARFR to convert one currency into another or to retrieve a current price. Its financial naming describes a notation operation; the examples are fictional calculations, not investment advice.

Use the positive denominator specified by the quotation convention. Negative inputs, noninteger denominators, invalid-input tokens and nonrepresentable fractional values are outside the original verified controls. The lesson has denominator-related remarks, but they do not become native test results in this guide.

AVERAGE operates on decimal values; ROUND changes numeric precision; TEXT formats a value as text. None supplies the missing denominator convention for an unlabeled quotation.

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.