DOLLARDE Function (Gnumeric)

• Introduced: Listed among the new financial functions in Gnumeric 0.19. No exact release date is asserted here.
• Documented support: Registered in Gnumeric 1.12.62 in the Financial Functions plugin. No retirement is established.
• Last functioning version: Unverified for this guide. Source registration and independent arithmetic do not certify a running application version.
• Scope: English function names and comma-separated formulas. The cached source comes from the October 13–14, 2026 audit; the full guide and reference calculations were checked on October 15, 2026.

DOLLARDE converts a fraction-coded quote into its decimal numeric value. For denominator 16, 1.03 represents 1 plus 3/16, so its decoded value is 1.1875. It is not a currency converter and does not interpret every number as an ordinary dollars-and-cents amount. The denominator determines how the digits after the decimal point are scaled.

Function-specific help and complete worksheet callback establish the operation described here.

=DOLLARDE(fractional_dollar,fraction)

• fractional_dollar: Number whose digits after the decimal point encode the fractional numerator.
• fraction: Denominator of that encoded fraction; the callback floors it before use. Both arguments are required.

The argument registration and callback were inspected together. A familiar function name in another spreadsheet is not a guarantee of the same input guards.

Put the encoded quote 1.03 in B2 and denominator 16 in B3. In B5 enter =DOLLARDE(B2,B3); the independent result is 1.1875. To check it by hand, subtract the integer part 1, interpret the remaining .03 as numerator 3, divide by 16, then add the integer part back. Keep the original quote and denominator beside the decoded number.

For a quote in thirty-seconds, =DOLLARDE(100.16,32) yields 100.5 because 16/32 is one half. Formatting the input as currency does not perform this decoding. Likewise, a displayed input 1.3 with denominator 16 represents numerator 30 under this two-place convention, not numerator 3.

These are independently calculated expected results from the pinned callback, with repeating or irrational values rounded to twelve decimal places. Error labels follow explicit source guards. They are not screenshots or native execution results.

The inspected scaling exponent is 1+FLOOR(LOG10(f-0.5)), where f is the floored denominator. For denominators 16 and 32 this gives two numerator places; for 8 it gives one. For a power of ten such as 10 it gives one place, so =DOLLARDE(1.5,10) remains 1.5. The implementation’s subtraction of 0.5 handles these power-of-ten boundaries.

The numerator is not rounded to a whole tick. =DOLLARDE(0.45,9) has reference result 0.5 because the single-place encoding represents 4.5/9. A numerator at least as large as the denominator can carry into the integer part: =DOLLARDE(1.16,16) gives 2. These results describe numeric conversion, not whether a quote follows a market’s allowed tick size.

A negative denominator returns #NUM! after flooring; zero returns #DIV/0!. Since the denominator is floored, 16.9 behaves as 16, while 0.5 becomes zero and errors. Use an explicit positive integer denominator so that a mistaken input is not silently converted into a different quoting convention.

Negative amounts are handled by decoding the absolute value and restoring the sign: -1.03 with denominator 16 becomes -1.1875. For an inverse check, DOLLARFR converts 1.1875 back to 1.03 with the same denominator. Do arithmetic on decoded values rather than adding encoded quotes directly. Keep a suitable number format when showing the encoded value so that significant numerator-place zeros remain clear to the reader.

Use actual numeric input cells for this fixture. Native handling of blank cells, numeric text, application-localized formula entry and display formatting was not executed here. Keep missing values distinct from deliberately supplied zero; using ISNUMBER to inspect inputs can prevent a text-formatted amount from being mistaken for a verified numeric fixture. The tables do not claim a particular result for untested coercions.

This guide uses the official pinned Gnumeric 1.12.62 source and independent reference arithmetic. It does not claim native execution, GUI validation, current-release parity or cross-product equivalence. The cached source date and the editorial checking date above describe separate activities. For an operational workbook, compare a small copy of this fixture with the installed version before relying on an imported schedule.

DOLLARFR, TRUNC, ROUND.