DOLLARDE in Zoho Sheet: Syntax and Worked Examples

=DOLLARDE(99.16;32) has an independently calculated expected result of 99.5. The quote means 99 plus 16/32, not the ordinary decimal quantity 99.16.

This distinction matters before arithmetic. A decimal-looking fractional quote is an encoding of a whole part and a fractional numerator; it is not already a decimal price or a percentage.

=DOLLARDE(fractional_rep; denominator)

Both arguments are shown as required in the official syntax. fractional_rep is the encoded quote; denominator tells you how many equal parts constitute one whole unit. This guide supplies positive integer denominators explicitly rather than assuming an omitted default or noninteger conversion rule.

For the bounded conventions used here, denominator 8 uses one numerator digit after the decimal point, while denominators 16 and 32 use a two-digit numerator block. Thus 100.2 with denominator 8 means 100+2/8, while 100.02 with denominator 32 would mean 100+2/32. Keep the denominator with every quote.

1. Enter 99.16 in A2 as a number.
2. Enter 32 in B2.
3. Enter =DOLLARDE(A2;B2) in C2.
4. Independently check 16/32=0.5, then add the whole part 99.

The expected decimal result is 99.5. Formatting C2 to two decimal places displays 99.50; that display is a decimal price, whereas the original 99.16 represented a fraction of 32.

The leading zero in the numerator block of 100.08 is meaningful to the notation even though the cell stores a number. A quote source must specify its encoding; these examples do not cover market-specific extra tick suffixes.

Suppose two fictional quotes are 100.08 in sixteenths and 100.24 in thirty-seconds. Their decimal values are 100.5 and 100.75, so the difference is 0.25 price units. Subtracting the encoded inputs directly would give 0.16, which is not the intended price difference.

For a mathematical inverse check, DOLLARFR with the same denominator should encode 100.5 as 100.08 for 16 and 100.75 as 100.24 for 32. This is an independently checked relationship between the two representations, not a Zoho execution result. Do not change the denominator halfway through a round trip.

If a fictional instrument is quoted per 100 of face value, a decimal price 99.5 corresponds to 995 for face value 1000 before any separate charges or accrued-interest adjustment. The per 100 convention is an assumption about that example, not something DOLLARDE supplies or validates.

Zoho’s article associates negative denominators with #NUM! and denominators strictly between 0 and 1, or omitted, with #DIV/0!. These are documentation predictions, not observed tests. The wording does not explicitly settle the exact zero boundary; this guide does not fill that gap with another application’s behavior.

Use numeric inputs and preserve enough precision. The reference does not establish every rule for negative encoded quotes, noninteger denominators or unusual numerator widths. The worked cases deliberately use positive, conventional eighths, sixteenths and thirty-seconds. This function converts notation; it does not evaluate whether a price is appropriate.

The official Zoho Sheet DOLLARDE article was checked October 18, 2026. This is rolling web-service documentation; the original introduction date, a numbered release, mobile/offline parity and a retirement endpoint are not established. The checked article does not identify the function as deprecated or retired.

All numerical results in this guide are independently calculated expectations or explicitly attributed documentation predictions. They were not executed in Zoho Sheet or its calculation engine. No native screenshot, export test or workbook run is claimed. The examples use the semicolon separators shown in Zoho’s English documentation.

• ROUND
• INT