Syntax. DOLLARDE(Number,Factor)
Definition. This function converts a number’s decimal point section, which is interpreted as the numerator of a fraction, into a decimal number, if the denominator is given.
Arguments
Number (required) The number whose decimal places are interpreted as the numerator of a fraction.
Factor (required) The denominator of the fraction for which the decimal section of Number is interpreted as the numerator. Factor expects an integer; therefore, the decimal places are truncated. If Factor is less than zero, DOLLARDE() returns the error #NUMBER!
. If it is equal to 0, the error #DIV/0!
is displayed.
Background. Until 2001, the stock quotations at the large stock markets in the United States were traditionally given in natural fractions. In other countries, interest was usually established in steps of eighths.
This function helps with the conversion and thus facilitates the quotation comparison.
Example. Figure 15-2 shows the function’s effects.
The results in column C interpret the first number 1.1 as 1½, 1¼, and sequentially. The interpretation as
is problematic, because the decimal places can be interpreted only up to the tenth. The result is displayed in column E. In column D, the number 2.2 is interpreted—the number to the left of the period is the integer, and the number to the right of the period represents the quarters, eighths, and so on. Sixteenths cannot be interpreted correctly here either.