Converts a dollar price expressed as a fraction into a dollar price expressed as a decimal number.
תחביר
DOLLARDE(fractional_dollar, fraction)ארגומנטים
fractional_dollarחובה
The number expressed as a fraction.
fractionחובה
The integer to use in the denominator of the fraction.
The DOLLARDE function is used to convert fractional pricing, such as securities prices, into decimal format. This is particularly useful for financial calculations where prices are traditionally quoted in fractions like 1/16 or 1/32.
=DOLLARDE(1.02, 16)→1.125Converts 1 and 2/16 into the decimal 1.125.
Select the cell
Click on the cell where you want to display the converted decimal value.
Enter the formula
Type =DOLLARDE(fractional_dollar, fraction) and replace the arguments with your specific values or cell references.
Excel will truncate the fraction argument to an integer.