• Home
  • DOLLARDE function

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:

ArgumentDescription
fractional_dollarAn integer part and a fraction part separated by a decimal symbol.
fractionAn 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

Article with the tag:
Browse all tags