Excel Functions

Excel DOLLARFR Function

Pinterest LinkedIn Tumblr

The Excel DOLLARFR function helps convert the dollar value which was in decimal into a fractional dollar value. In MS-Excel this categorized under financial function.


Purpose of Excel DOLLARFR Function

To convert decimal numbers to fractional dollar numbers, it helps in products like securities prices.

Return value

DOLLARFR function returns dollar decimal into dollar fraction value.


=DOLLARFR(decimal_dollar, fraction)


decimal_dollarThe decimal number that need to be converted.Mandatory
fractionThe denominator in the fractional unit.Mandatory

Usage note

  • If a fraction is not an integer, it is truncated.
  • If a fraction is less than 0, the function returns the #NUM! error value.
  • If a fraction is 0, the function returns the #DIV/0! error value.
  • The value for fraction must be greater than zero.


Since 2007 for Windows.
Since 2011 for Mac.

Related Posts

Write A Comment