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.


  • 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 O’Reilly online learning.

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