Syntax. DOLLARFR(Number,Factor)

Definition. This function converts the decimal places of a decimal number into the numerator of a fraction with a given denominator and displays them in the decimal places.


  • Number (required) The decimal number whose decimal places are to be converted

  • Factor (required) The denominator for which the numerator is calculated. If Factor is not an integer, the decimal places are truncated. A positive Factor is expected. If the argument equals zero, DOLLARFR() returns the error #DIV/0!. If it is negative, the error #NUMBER! is displayed.

Background. Until 2001, the stock quotations in the large stock markets in the United States were traditionally done with natural fractions. In other countries, interest ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.