• 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

Host ONLYOFFICE Docs on your own server or use it in the cloud

Article with the tag:
Browse all tags