DOLLARDE

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

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.

Make sure that the fraction you use corresponds to the format accepted in your country or in your professional field.