DOLLARDE Function in ONLYOFFICE Spreadsheet Editor: Syntax and Examples

=DOLLARDE(1.02,16) is expected to return 1.125: the input encodes 1 and 2/16, not the ordinary decimal amount 1.02. =DOLLARDE(100.16,32) is expected to return 100.5, meaning 100 and 16/32.

The official help describes an integer and fractional part separated by a decimal symbol. This is a numeric quote convention. It is not currency exchange, percentage conversion or a text parser for strings such as 100-16 or 100 16/32.

=DOLLARDE(fractional_dollar, fraction)

Both arguments are required. fraction supplies the denominator, such as 8, 16 or 32. In the inspected implementation, the positive denominator is floored to an integer b and the scale is 10^CEILING(log10(b)). The integer part of the quote is taken toward zero; the remaining signed decimal part is multiplied by that scale and divided by b.

For b=16 or 32, the scale is 100, so a numerator of 2 is encoded as .02, not .2. For b=8, the scale is 10, so a numerator of 2 is encoded as .2. Use explicit integer denominators rather than relying on flooring.

1. Enter Encoded quote in A1, Denominator in B1 and Decimal value in C1.
2. Enter the input pairs below into A2:B6 as numbers.
3. Put =DOLLARDE(A2,B2) in C2 and fill down.
4. Retain A and B so the original convention remains auditable.

Binary floating-point storage can affect the last displayed digits. These values are independently calculated rational expectations, not exact application display strings. Use an appropriate tolerance when testing them.

Suppose a fictional quote column contains 100.16 and 100.24, both in thirty-seconds. Their expected decimal values are 100.5 and 100.75, so the difference is 0.25. Directly subtracting the encoded numbers gives 0.08, which is a difference in their decimal encoding, not the economic price difference.

Convert both quotes before subtraction, averaging or applying a monetary scale. If a quote is per 100 face value, retain that unit explicitly; the function does not know the security’s face amount. A quote stored as text with a dash, slash or suffix must be parsed separately and accurately before using this two-number interface.

• A negative denominator returns #NUM! in the source.
• Zero, or a positive denominator below 1 that floors to zero, returns #DIV/0!.
• Positive fractional denominators are floored: =DOLLARDE(1.02,16.9) is expected to behave like denominator 16. This is a conversion rule, not a reason to store imprecise denominator metadata.
• Empty scalar inputs follow #N/A, Boolean scalars #VALUE!, and existing input errors propagate in this wrapper.
• There is no explicit guard requiring an integer numerator smaller than the denominator. =DOLLARDE(1.32,32) is expected to return 2, since 32/32 adds a whole unit. A successful result does not prove that the quote was conventionally encoded.

Do not format encoded quotes as percentages. A percent sign changes the numeric value entered, while denominator 32 means thirty-seconds of a whole unit. Keep the fraction convention in its own column and use ordinary numeric formatting for the decimal result.

Checked October 18, 2026 against the official DOLLARDE 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