Documentation/Calc Functions/DOLLARDE

Function name:
DOLLARDE

Category:
Financial Analysis

Summary:
Converts a quotation that has been given as a decimal fraction into a decimal number.

Syntax:
DOLLARDE(FractionalDollar; Fraction)

Returns:
Returns a decimal number.

Arguments:
FractionalDollar is a real number given as a decimal fraction (integer part and a fraction part which is separated by a decimal symbol) or a reference to the cell containing that number.

Fraction is a positive whole number that is used as the denominator of the decimal fraction.


 * If Fraction is not an integer, then it will be truncated to an integer.
 * If after truncation Fraction is less than or equal to 0, then the function returns an error value. Alternatively, Fraction should be greater than or equal to 1.

Additional details:

 * The formula for DOLLARDE is:

where Denominator is Fraction and Fractional is FractionDollar.

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/DOLLARFR DOLLARFR]

[[Special:MyLanguage/Documentation/Calc_Functions/TRUNC TRUNC]

ODF standard:
Section 6.12.16, part 2

Equivalent Excel functions:
DOLLARDE