DOLLARDE Function (LibreOffice Calc)

=DOLLARDE(FractionalDollar; Fraction)

There are two required arguments and no optional arguments or documented defaults. Semicolons are used in the formula examples for the tested English-name Calc installation. The decimal separator and the displayed function-argument separator may differ with your locale and Calc formula settings; use the separators shown in your Calc interface, and check the Formula Bar if a pasted example does not parse.

LibreOffice Help calls the arguments FractionalDollar and Fraction. The OpenDocument 1.4 OpenFormula definition, §6.12.16 gives the corresponding standard form DOLLARDE(Number Fractional; Integer Denominator) and requires a positive denominator. The ODF name is DOLLARDE; this tutorial does not assume Excel-only syntax or an undocumented name alias.

For a quote of 1.02 using a denominator of 16, the whole part is 1, and the quoted numerator is 2, yielding 1 + 2/16 = 1.125. A price of 1.02 using a denominator of 32, however, means 1 + 2/32 = 1.0625. Thus, the same input value yields different true prices when the denominator changes.

The fractional numerator is recorded as a decimal suffix with enough places for the denominator’s quoted range. For the denominations commonly seen in bond quotations:

A useful warning for entry: 1.10 entered as a number becomes numerically indistinguishable from 1.1. With denominator 32, the latter is read as 10/32, not 1/32: =DOLLARDE(1.1;32) is 1.3125. Adding trailing zeros through number formatting does not alter a stored numerical quotation. If you need to preserve the exact exchange notation, store the display notation in a separate text column, and construct the numeric input deliberately.

Enter the following formulas directly into blank cells. The decimal numbers in the result column are full-precision values, not results from manually rounding a securities price.

All ten results above are covered by the saved test evidence or directly follow an independently checked formula; the saved evidence also records many more cases, including noncanonical quotes and numeric precision tests. LibreOffice’s own two illustrated examples are verified against the official Help.

Set up a small quote-conversion table

Put these values into a new sheet:

In C2, enter:

=DOLLARDE(A2;B2)

The expected result is 100.15625. Fill the formula into C3; the result is 99.375, because 12/32 = 0.375. You can now calculate the decimal price difference with =C2-C3, which is 0.78125. Do not subtract the quoted values directly: 100.05-99.12 is a subtraction of codes, not of decoded prices.

For a safer working table, keep an extra text column identifying the pricing convention (32nds, 16ths, and so forth). An imported quote without its denominator is not enough information to reconstruct the original economic value reliably.

For a positive two-digit fractional quote with denominator 32, DOLLARDE effectively interprets the suffix as a numerator over 32. For 100.05:

whole price = 100
encoded numerator = 05 = 5
fractional value = 5 / 32 = 0.15625
true price = 100 + 0.15625 = 100.15625

For a denominator of 8, the common fractional suffix is one digit; for 16 or 32, two; for 128, three. The decimal-power scaling is why blindly calculating =(A2-TRUNC(A2))/B2 is not equivalent to DOLLARDE for a two-digit quotation.

A pedagogical decomposition for positive, canonical two-digit quotes in thirty-seconds is:

=TRUNC(A2)+((A2-TRUNC(A2))*100)/32

For A2=100.05, the result is 100.15625. This decomposition is for understanding that specific quote format, not a drop-in replacement for all denominators, negative prices, precision cases, or other programs. Prefer the actual DOLLARDE function for routine use.

OpenFormula documentation nuance: ODF 1.4 §6.12.16 publishes a short algebraic expression for DOLLARDE that does not explicitly show the decimal-place scaling needed to reproduce LibreOffice Help’s own 1.02;16 example. The exact ODF spelling and positive-denominator constraint are supported, but the printed algebra should not be substituted verbatim for the validated Calc calculation. That discrepancy was reviewed in the official documents; it is not evidence of executing every ODF implementation.

Compare two quoted securities on the same denominator

Suppose the bid is 100.05 and the ask is 100.07, both in thirty-seconds. You can compute the spread as:

=DOLLARDE(100.07;32)-DOLLARDE(100.05;32)

Result: 0.0625, or 2/32. If you instead subtract the quote numbers without decoding, you would calculate 0.02, which is not the economic difference.

Use a denominator stored with each imported quote

If column A contains quoted values and column B contains the denominator for each row, use:

=DOLLARDE(A2;B2)

Copy down. A quote from a sixteenths exchange and one from a thirty-seconds exchange must not share a hardcoded denominator; carry the denominator alongside each quotation.

Reject invalid denominators before converting

For imported data, this simple check prevents common denominator mistakes:

=IF(OR(B2<=0;B2<>TRUNC(B2));"Check denominator";DOLLARDE(A2;B2))

In the usual case it displays the decimal price. If the denominator is zero, negative, or nonintegral, it prints a warning instead. This is a data-quality policy, not a claim that Calc itself rejects all nonintegers: native Calc 25.2.3.2 truncated 2.9 to 2 in this function. This check also does not verify that the quote numerator is in range or on an exchange’s permitted tick grid; that requires separate business-rule validation.

Convert back for display or audit

The inverse function is DOLLARFR. For instance:

=DOLLARFR(DOLLARDE(100.05;32);32)

returns a numeric quote of 100.05 in the tested version. Such round trips verify arithmetic consistency for well-formed quotations, not preservation of original printed notation or zero padding. An invalid numerator can normalize to a different-looking quote after conversion.

The error codes and coercion observations are measured Calc 25.2.3.2 behavior, not universal statements for all editions. If you get #NAME? or Err:509, check whether the function name is supported by your installed build, separators match the active formula locale, and the formula has been pasted without typographic quote marks. For numeric text with locale-dependent decimal or grouping marks, examine NUMBERVALUE instead of trusting automatic coercion.

Numerical precision: Calc stores ordinary numeric values with floating-point precision. A native result such as 100.03125000000001 may appear internally in a test harness even when the meaningful price is exactly 100.03125 to the intended scale. Format or round the final monetary presentation according to your requirements; do not round away ticks prematurely before performing spread or portfolio calculations. See ROUND and TRUNC.

Do not assume other applications accept formulas, error codes, or quotes identically because the function name matches. ODF file interchange and imported spreadsheets should be checked on representative data.

Does DOLLARDE convert currencies or exchange rates?

No. It changes the notation of a quotation from whole units plus a fractional numerator to an ordinary decimal value in the same unit. It does not retrieve exchange rates, convert CAD to USD, add currency symbols, or apply a stock-market data feed.

Why does =DOLLARDE(1.1;8) equal =DOLLARDE(1.02;16)?

The first quotation means 1 + 1/8, and the second means 1 + 2/16. Both fractions equal 0.125, so both formulas return 1.125. The two notations can represent the same economic price.

Why is my price 100.05 not $100.05?

If the quote is in thirty-seconds, .05 encodes the numerator 5, so the price is 100 + 5/32 = 100.15625. Without knowing the denominator, you cannot safely interpret the quote.

Is the result already rounded to a market tick?

No. DOLLARDE decodes the supplied number. It does not validate whether the encoded numerator is an integer or below the denominator; tests showed that noncanonical quotes may still calculate successfully. Tick validation is a separate process.

Does it preserve two-digit quote suffixes such as 1.10?

No. 1.10 and 1.1 are the same ordinary numeric value. To preserve a particular market print format, keep the original quote as text in a separate column and manage display conventions separately. DOLLARDE returns a numeric decimal price.

• DOLLARFR — the inverse: decimal price to fractional quotation.
• TRUNC — isolate an integer component in a validation or explanatory formula.
• MOD — inspect remainders when designing quote validation.
• ROUND — round the final numerical result after calculation.
• NUMBERVALUE — clean numerical imports that use varying separator conventions.

Primary references, reviewed 13 October 2026: LibreOffice Calc 26.8 Financial Functions Help — DOLLARDE; OpenDocument 1.4 OpenFormula §6.12.16; Microsoft Excel DOLLARDE documentation; Google Sheets DOLLARDE documentation. Testing: native LibreOffice Calc 25.2.3.2 (Linux); independent Python Decimal expected-value calculations. No Excel or Sheets execution.