The DOLLARDE function returns the fractional price as a decimal number.
This function can be useful for financial analysis, especially when working with fractional values, which are common in securities trading.
Syntax
DOLLARDE(fractional_price, unit)
Argument |
Description |
Permitted values |
|---|---|---|
fractional_price |
Price in fractional format |
Fraction or a reference to a cell containing a number |
unit |
The number that indicates the number system in which cents (the fractional part) are represented |
Positive integer: most often 8, 16, 32, or 64 |
Examples of use
Conversion of 3.25 dollars (3 dollars and 25/100):
=DOLLARDE(3.25, 100)
The result will be 3.25, since the fractional part is already in decimal format.
Conversion of 2 dollars and 11/16 dollars:
=DOLLARDE(2.11, 16)
This formula will return 2.6875.
Notes
Make sure that the fraction you use corresponds to the format accepted in your country or in your professional field.