DOLLARDE Function

The DOLLARDE function is one of the financial functions. It is used to convert a dollar price represented as a fraction into a dollar price represented as a decimal number.

Syntax

DOLLARDE(fractional_dollar, fraction)

The DOLLARDE function has the following arguments:

Argument Description
fractional_dollar An integer part and a fraction part separated by a decimal symbol.
fraction An integer you wish to use as a denominator for the fraction part of the fractional_dollar value.

Notes

For example, the fractional_dollar value, expressed as 1.03, is interpreted as 1 + 3/n, where n is the fraction value.

How to apply the DOLLARDE function.

Examples

The figure below displays the result returned by the DOLLARDE function.

DOLLARDE Function