How to use DOLLARDE Function in Excel

DOLLARDE (an Analysis ToolPak function) allows you to convert a fractional dollar amount to a decimal amount. You can use this function to convert the price of a security, typically represented as a fractional amount, to a decimal amount that can be used for other calculations

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.

Example: Let’s look at some Excel DOLLARDE function examples and explore how to use the DOLLARDE function as a worksheet function in Microsoft Excel:

Syntax:  =DOLLARDE(A2,B2)

Result:

Based on the Excel spreadsheet above, the following DOLLARDE examples would return:

Note:

• If the supplied fraction argument is < 0,#NUM! error will occur.
• If the supplied fraction argument = 0,#DIV/0! error will occur.
• If either of the supplied arguments is non-numeric,#VALUE! error will occur.
• If fraction is not an integer, it is truncated