Documentation/Calc Functions/DOLLARFR

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

DOLLARFR

Category:

Financial Analysis

Summary:

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

Syntax:

DOLLARFR(Decimal Dollar; Fraction)

Returns:

Arguments:

Decimal Dollar is a decimal number.

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

Additional details:

Examples:

=DOLLARFR(1.125;16) converts into sixteenths. The result is 1.02 for 1 plus 2/16.

=DOLLARFR(1.125;8) converts into eighths. The result is 1.1 for 1 plus 1/8.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: