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:
Based on the Excel spreadsheet above, the following DOLLARDE examples would return:
- 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