The DOLLARDE function in Excel is a powerful tool designed to convert dollar prices, which are expressed as fractions, into decimal representations. This function is especially useful for financial calculations, where precision and clarity in monetary values are crucial.

Syntax

DOLLARDE(fractional_dollar, fraction)

• fractional_dollar: This is the dollar price expressed as a fraction.
• fraction: This represents the denominator of the fraction, indicating into how many parts the dollar is divided.

Example #1

DOLLARDE(3.25, 16)

This function will convert the fractional dollar price of 3 25/16 into a decimal format. The result will be 3.4375.

Example #2

DOLLARDE(2.5, 8)

This example converts 2 1/2 into a decimal, resulting in 2.625 as the output.

Example #3

DOLLARDE(4.75, 32)

Here, the function translates 4 75/32 into decimal form, providing a result of 4.84375.

Error handling

• VALUE!: This error occurs when the fractional dollar is not a numeric value.
• NUM!: This indicates that the fraction parameter is less than 1, which is not valid.
• DIV/0!: This error arises when the fraction parameter is set to zero, leading to division by zero.

Conclusion

The DOLLARDE function is an essential tool for financial analysis in Excel. By converting fractional dollar amounts into decimal form, it enhances the accuracy and clarity of monetary calculations, making it invaluable for budget planning, investment analysis, and financial reporting.