DOLLARFR()
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.
Arguments
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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
