DOLLARDE function

The DOLLARDE function in Excel is used to convert a fractional dollar amount (expressed as a mixed number) into a decimal number. This is useful when dealing with financial data where amounts are often written as dollars and cents, such as “$1 1/2” or “$2 3/4.”

Syntax

DOLLARDE(fractional_dollar, fraction)

Parameters

• fractional_dollar: The fractional dollar amount (the mixed number). For example, if you have “$2 3/4,” the value would be 2.75.
• fraction: The denominator of the fraction. This specifies the fraction in which the dollar amount is expressed. For example, if the fractional amount is expressed as a fraction out of 4 (like 1/4, 2/4), you would enter 4 here.

How It Works

The DOLLARDE function converts a fractional dollar amount (such as $1 1/2) into its decimal equivalent. It takes the whole number part and adds the fractional value, which is calculated based on the specified fraction.

The formula is essentially:

$$\text{Decimal Value} = \text{Whole Dollar} + \left(\frac{\text{Numerator of Fraction}}{\text{Fraction Denominator}}\right)$$

Example

Let’s say you have the following mixed number:

• $3 1/4 (which means $3 and one-fourth of a dollar).

You would use the following formula to convert it to a decimal:

=DOLLARDE(3.25, 4)

Explanation of the Example:

• 3.25: This is the fractional dollar amount, which represents $3 1/4. (The whole dollar part is 3, and the fractional part is 1/4, which is represented as 0.25 in decimal.)
• 4: This is the denominator of the fraction (since the fractional part is 1/4).

The DOLLARDE function will return 3.25, which is the decimal equivalent of “$3 1/4.”

Important Notes

• Whole Dollar and Fraction: The fractional dollar should include both the whole dollar part and the fractional part combined (e.g., for “$1 1/2”, you can write 1.5).
• Denominator: The fraction denominator should reflect the denominator of the fraction you are working with (e.g., 2 for halves, 4 for quarters, etc.).

Summary

The DOLLARDE function is useful for converting a mixed number (dollars and fractions of a dollar) into a decimal number, which can be easier to work with in calculations, especially in financial scenarios.