# Documentation/Calc Functions/DOLLARDE

Jump to navigation
Jump to search

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## 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**.

## 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 |

## Related LibreOffice functions:

## ODF standard:

## Equivalent Excel functions:

DOLLARDE