DOLLARFR Function in ONLYOFFICE Spreadsheet Editor: Syntax and Examples

=DOLLARFR(1.125,16) is expected to return the numeric encoding 1.02, meaning 1 and 2/16. =DOLLARFR(100.5,32) is expected to return 100.16, meaning 100 and 16/32. The returned number is an encoded quote, not an ordinary decimal price for further arithmetic.

=DOLLARFR(decimal_dollar, fraction)

Both inputs are required. decimal_dollar is the ordinary decimal value and fraction is the denominator. The official help explains the integer-plus-fraction convention. The 10.0.0.169 implementation floors a positive denominator to b, separates the integer part toward zero and encodes the signed remainder as remainder*b / 10^CEILING(log10(b)).

For denominators 16 and 32 the encoding uses a scale of 100. For denominator 8 the scale is 10. No optional rounding or text-format argument is provided.

1. Put ordinary numeric prices in A2:A6 and the desired denominators in B2:B6.
2. Enter =DOLLARFR(A2,B2) in C2 and fill down.
3. Keep column A for calculations; label C clearly as an encoded quote.
4. Choose a display precision that does not hide meaningful numerator digits.

The two results 1.02 describe different values with different denominators. A quote column without its denominator metadata is therefore ambiguous. The output remains numeric; trailing zeros are a display choice, not preserved text characters.

=DOLLARFR(1.1,32) is expected to return 1.032, because the fractional amount 0.1 represents 3.2 thirty-seconds. The implementation does not round that numerator to 3 or 4. Displaying only two decimal places may make the cell look like 1.03 while its stored numeric value remains 1.032.

If a fictional reporting specification explicitly requires nearest thirty-second ticks, round the ordinary decimal value to that grid before encoding. For example, =DOLLARFR(ROUND(1.1*32,0)/32,32) is expected to yield 1.03: 35.2 ticks round to 35, 35/32=1.09375, and the remainder is 3/32. That rounding is a separate decision, not part of DOLLARFR. Other quote systems can use different rounding or subdivisions; use their actual specification.

For exact tick values, a round trip through the paired conversion should preserve the original decimal amount within floating-point tolerance. The expected pair is 100.5 → DOLLARFR with denominator32 → 100.16 → DOLLARDE with denominator32 → 100.5. Keep the same denominator in both directions.

Do arithmetic on the original decimal values, not on encodings. Encoded 100.16 and 100.24 differ numerically by 0.08, but their represented prices differ by 8/32=0.25. Nor is an encoding such as 1.02 an interest rate of 102%; percentage formatting would obscure its intended meaning.

The inspected source returns #NUM! for a negative denominator and #DIV/0! for zero or a positive denominator below 1. A denominator of 16.9 is floored to 16. Blank scalar arguments and Boolean scalar arguments have separate #N/A and #VALUE! branches; use numeric inputs as shown.

Negative ordinary values are supported by the sign-preserving formula. The function does not attach a currency symbol, slash, denominator label or market-specific suffix. If another system requires such text, construct and validate that presentation separately instead of assuming the numeric encoding is a complete exchange format.

Checked October 18, 2026 against the official DOLLARFR help and official SDKJS source tagged v10.0.0.169. Desktop Editors 10.0 was released October 13, 2026. The original introduction version for this individual function is not established; current help does not mark it retired or deprecated.

All results in this guide are expected values from documentation, source inspection and independent arithmetic, not application observations. Neither the application nor its calculation engine was used to test these examples. The tag matches the installed version/build designation but does not establish identical behavior in every older release, mobile client, server deployment or imported workbook. Examples use English names and comma argument separators; adapt separators to editor settings. These fictional calculations explain a function, not an investment or borrowing recommendation.

• ROUND
• TRUNC