Learn How to Use Microsoft Excel DOLLARDE Function

Microsoft Excel DOLLARDE Function

The main purpose of the Microsoft Excel DOLLARDE function is to convert dollar prices as fractions to decimals. That implies, with the help of DOLLARDE function you can able to convert a dollar price entered with a special notation to a dollar price displayed as a decimal number.  It should be noted that the DOLLARFR function does the opposite conversion. So, with the help of DOLLARDE function, you can able to convert the dollar price a a fraction to a decimal.

Return Value of DOLLARDE Function

The return value will be the equivalent decimal number. 

Syntax of DOLLARDE Function

=DOLLARDE(fractional-dollar, fraction)

Where the arguments:

• fractional-dollar: This is the dollar component in special fractional notation.
• fraction: This is the denominator in the fractional unit. 8 = 1/8, 16 = 1/16, 32 = 1/32, etc.

How to Use Microsoft Excel DOLLARDE Function?

So we know that Microsoft Excel DOLLARDE function you can able to convert dollar price as a fraction to decimal. That implies, with the help of DOLLARDE function you can able to convert a dollar price entered with a special notation to a dollar price displayed as a decimal number.  It should be noted that the DOLLARFR function does the opposite conversion. So, with the help of DOLLARDE function, you can able to convert the dollar price a fraction to a decimal.

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel