DOLLARFR 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.

DOLLARFR encodes a fractional numerator in the digits after the decimal point. For denominator 16, decimal 1.1875 becomes 1.03, meaning 1 plus 3/16. The returned value is still numeric; it is not text such as “1 3/16” and does not alter the cell’s number format automatically.

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

=DOLLARFR(decimal_dollar,fraction)

• decimal_dollar: Ordinary decimal number to encode.
• fraction: Denominator for the fractional quote; floored 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 decimal value 1.1875 in B2 and denominator 16 in B3. In B5 enter =DOLLARFR(B2,B3); the reference result is 1.03. The fractional part .1875 times 16 is numerator 3, which is stored as .03 because this denominator uses two numerator places. In B6 enter =DOLLARDE(B5,B3) to reconstruct 1.1875.

For decimal 100.5 in thirty-seconds, =DOLLARFR(100.5,32) gives 100.16. A format that shows two decimal places makes the quote convention visible. The encoded output is not an ordinary decimal monetary value suitable for totaling: decode it before arithmetic, and retain the denominator as part of the record.

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 function uses the same denominator-dependent scaling as DOLLARDE. With denominator 8, decimal .25 becomes .2 because the numerator is 2 and only one decimal place is used. With denominator 16, .1875 becomes .03. At denominator 10 the scaling is one decimal place, so .5 stays .5. These examples explain why applying a fixed two-place assumption to all denominators is incorrect.

DOLLARFR does not round the numerator to an allowed tick. =DOLLARFR(0.2,16) has reference output .032, encoding numerator 3.2/16. Displaying only two decimal places would hide information and show .03, which decodes to a different value if re-entered. If a business process needs whole ticks, define and apply that rounding policy explicitly before encoding.

The callback floors the denominator. Thus 16.9 uses 16; a positive denominator below 1 becomes zero and returns #DIV/0!. Negative denominators return #NUM!, including values between -1 and zero after flooring. A negative amount is encoded by processing its magnitude and restoring the sign, so -1.1875 becomes -1.03 with denominator 16.

A value displayed as 1.3 is ambiguous to a human without its denominator and decimal-place convention. With denominator 16, it can encode numerator 30; it is not automatically 1 plus 3/16. Keep a suitable format and use a decode/re-encode check when importing quotes. Binary floating-point arithmetic may introduce tiny residual differences, so compare round trips at the precision appropriate to the data rather than expecting every binary representation to be identical.

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.

DOLLARDE, TRUNC, ROUND.