DOLLARDE()
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 ...
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.
