DOLLARDE
The DOLLARDE function converts a dollar price expressed as a fraction into a decimal number. It is often used in financial modeling and monetary calculations.
Syntax 🔗
=DOLLARDE(FractionalDollar, [Fraction])
FractionalDollar | The dollar price value expressed as a fraction. |
Fraction (Optional) | The denominator of the fraction. Defaults to 32 if omitted. |
About DOLLARDE 🔗
Use the DOLLARDE function in Excel to convert dollar values from fractional to decimal form. This function helps you manage financial calculations and monetary analysis tasks more efficiently. It's a useful tool for ensuring precision in financial figures.
Examples 🔗
Let's say you have a bond with a price quoted at 99 29/32. You want to convert this fractional dollar price into a decimal value. Use the formula: =DOLLARDE(99+29/32)
Imagine you have a stock trading at 50 1/8. You wish to convert this dollar price fraction to a decimal. Use the formula: =DOLLARDE(50+1/8, 16) to specify a denominator of 16.
Notes 🔗
Provide the FractionalDollar argument without including the dollar sign ($). If you omit the Fraction argument, it will default to 32. Adjust this based on the fractional notation or denominator that applies to the dollar price values you are working with.
Questions 🔗
The DOLLARDE function aids in financial modeling by facilitating the conversion of fractional dollar prices into decimal form, enabling smoother calculations and analysis of monetary values within Excel spreadsheets.
Is the FractionalDollar argument in the DOLLARDE function sensitive to formatting?Yes, the FractionalDollar argument should be in a recognizable format without special characters or currency symbols. Ensure it follows a standard fractional representation (e.g., 99 29/32) for accurate conversion.
Can I customize the fraction denominator in the DOLLARDE function?Yes, you can specify a custom fraction denominator using the optional Fraction argument in the DOLLARDE function. This allows you to adapt the conversion based on the specific fraction format used in the dollar price values.