DOLLARDE function
This article describes the formula syntax and usage of the DOLLARDEfunction in Microsoft Excel.
Description
Converts a dollar price expressed as an integer part and a fraction part, such as 1.02, into a dollar price expressed as a decimal number. Fractional dollar numbers are sometimes used for security prices.
The fraction part of the value is divided by an integer that you specify. For example, if you want your price to be expressed to a precision of 1/16 of a dollar, you divide the fraction part by 16. In this case, 1.02 represents $1.125 ($1 + 2/16 = $1.125).
Syntax
DOLLARDE(fractional_dollar, fraction)
The DOLLARDE function syntax has the following arguments:

Fractional_dollar Required. A number expressed as an integer part and a fraction part, separated by a decimal symbol.

Fraction Required. The integer to use in the denominator of the fraction.
Remarks

If fraction is not an integer, it is truncated.

If fraction is less than 0, DOLLARDE returns the #NUM! error value.

If fraction is greater than or equal to 0 and less than 1, DOLLARDE returns the #DIV/0! error value.
Example
The example may be easier to understand if you copy it to a blank worksheet.
How do I copy an example?

Select the example in this article.
Important Do not select the row or column headers.
Selecting an example from Help

Press CTRL+C.

In Excel, create a blank workbook or worksheet.

In the worksheet, select cell A1, and press CTRL+V.
Important For the example to work properly, you must paste it into cell A1 of the worksheet.

To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas tab, in the Formula Auditing group, click the Show Formulas button.
After you copy the example to a blank worksheet, you can adapt it to suit your needs.

