Author: Oscar Cronquist Article last updated on September 14, 2018

The DOLLARFR function converts a decimal number to its equivalent in fractional numbers, used in securities denominated in dollars.

Excel Function Syntax

DOLLARFR(decimal_dollar, fraction)


decimal_dollar Required. A decimal number, example 1.25.
fraction Required. An integer that represents the denominator of a fraction. The numerator is always 1.


The DOLLARFR returns

  • #NUM error value if fraction < 0 (zero).
  • #DIV/0! error value if fraction = 0 (zero).