O'Reilly logo

Microsoft® Excel® 2010 Formulas & Functions Inside Out by Helmut Reinke Egbert Jeschke Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required