DOLLARFR in Zoho Sheet: Syntax and Worked Examples

=DOLLARFR(99.5;32) has an independently calculated expected result of 99.16. The output represents 99+16/32. It must not be read as the ordinary decimal price 99.16.

DOLLARFR converts the representation of a number. It does not convert currency, compute a discount percentage or round a price to an allowed trading tick.

=DOLLARFR(decimal; denominator)

Zoho’s official reference takes a decimal value and the denominator for the fractional representation. Both are supplied explicitly in these examples.

For denominators 8, 16 and 32, the mathematical encoding used here places the numerator after the decimal point in one digit for eighths and two digits for sixteenths or thirty-seconds. The result remains a numeric cell value, so ordinary arithmetic on that encoded result can be misleading.

Enter 99.5 in A2 and 32 in B2. In C2 enter =DOLLARFR(A2;B2).

The whole part is 99. Multiply the decimal fraction 0.5 by 32 to obtain numerator 16. Place that numerator in the two-digit fractional-quote block, giving 99.16. The independently calculated result is an encoding of the same value as 99.5, not a loss of 0.34 price units.

Each input was chosen to be exactly representable in the stated fractional units. That makes the numerator and expected representation transparent without relying on undocumented rounding behavior.

Keep a decimal calculation column separate from a quote-display column. For example, decimal prices 100.5 and 100.75 differ by 0.25. Encoding them with denominator 32 gives 100.16 and 100.24; subtracting those encodings gives 0.08, which is not the decimal price difference.

A useful independent check decodes the result with DOLLARDE using the same denominator. For example, 100.16 in thirty-seconds means 100+16/32=100.5. The relationship is checked arithmetically here; no Zoho calculation was run.

If an input is not an exact multiple of 1/denominator, a representation conversion and a tick-rounding policy are separate questions. Decide the required rounding rule before encoding a quote; do not assume DOLLARFR enforces a market’s permitted tick size. Avoid prematurely rounding the decimal input because that changes the value being represented.

Label the denominator in the report. A result like 100.2 has a different interpretation under eighths than a two-digit quote block under thirty-seconds. Formatting can also hide a zero that helps a reader recognize the expected block width; make the notation convention explicit in column headings.

A fraction-style cell number format is a presentation feature. DOLLARFR instead produces an encoded numeric result. The two should not be treated as the same transformation when formulas later use the cell’s stored number.

The official article lists #NUM! for a negative denominator, and #DIV/0! for a denominator strictly between 0 and 1 or an omitted denominator. It does not explicitly resolve the exact zero case or every noninteger-denominator rule. No executed error behavior is claimed here.

The examples use positive numbers with explicit integer denominators. Negative quotes, extra market-specific tick markers and cross-application export behavior are outside the checked scope. These are notation examples, not recommendations about buying or selling a financial product.

The official Zoho Sheet DOLLARFR 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
• ROUNDDOWN