# Documentation/Calc Functions/DOLLARDE

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.

• The formula for DOLLARDE is:

where Denominator is Fraction and Fractional is FractionDollar.

## Examples:

Formula Description Returns
=DOLLARDE(1.02;16) The function will convert the given quotation as a decimal fraction into a decimal number. Here, it stands for 1 and 2/16. 1.125
=DOLLARDE(1.1;8.2) The function will convert the given quotation as a decimal fraction into a decimal number. Here, it stands for 1 and 1/8 (8.2 is truncated to 8). 1.125
=DOLLARDE(-1.1;8.2) The function will convert the given quotation as a decimal fraction into a decimal number. Here, it stands for 1 and -1/8 (8.2 is truncated to 8). -1.125
=DOLLARDE(1.1;0.9) The function returns an error value since Fraction is less than 1. Err:502

DOLLARDE