# Documentation/Calc Functions/EUROCONVERT

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

## Function name:

EUROCONVERT

## Category:

Mathematical

## Summary:

Converts currency values between the euro and various legacy European national currencies, using the fixed exchange rates set by the European Commission when countries adopted the euro.

## Syntax:

EUROCONVERT(**Value**; **FromCurrency**; **ToCurrency** [; **FullPrecision** [; **TriangulationPrecision**]])

## Returns:

Returns a real number that is the converted amount expressed in the target currency.

## Arguments:

**Value** is a real number, or a reference to a cell containing that number, that is the amount to be converted expressed in the currency specified by the **FromCurrency** argument.

**FromCurrency** is a text string, or a reference to a cell containing a text string, that specifies the currency to be converted from. One of 20 strings - "ATS", "BEF", "CYP", "DEM", "EEK", "ESP", "EUR", "FIM", "FRF", "GRD", "IEP", "ITL", "LTL", "LUF", "LVL", "MTL", "NLG", "PTE", "SIT", and "SKK". These strings are not case sensitive and so for example, "eur" is equivalent to "EUR" or "eUr". The meaning of these abbreviations is clarified in the table in the #Additional details: section below.

**ToCurrency** is a text string, or a reference to a cell containing a text string, that specifies the currency to be converted to. One of 20 case-insensitive strings, as listed for the **FromCurrency** argument.

**FullPrecision** is a boolean, or a reference to a cell containing that boolean, that controls how the result is rounded. If omitted, set to 0, or set to FALSE, then the result is rounded according to the default number of decimals of the **ToCurrency**. This default number is listed in the *Decimals* column of the table in the #Additional details: section below. If a non-zero value is provided for this argument, the result is not rounded.

**TriangulationPrecision** is a positive integer, or a reference to a cell containing that number. If a value greater that or equal to 3 is provided, the intermediate result of a triangular conversion (currency1→EUR→currency2) is rounded to that precision. If omitted, the intermediate result is not rounded. Also if **ToCurrency** is "EUR", **TriangulationPrecision** is used as if triangulation was needed and conversion from EUR to EUR was applied.

- If any of
**Value**,**FullPrecision**, or**TriangulationPrecision**are non-numeric, then EUROCONVERT reports a #VALUE! error. - If either
**FromCurrency**or**ToCurrency**is not one of the expected strings, then EUROCONVERT reports an invalid argument error (Err:502). - If
**TriangulationPrecision**is a non-integer value, then EUROCONVERT truncates it by taken its floor value. - If the value of
**TriangulationPrecision**is less than 3, then EUROCONVERT reports an invalid argument error (Err:502).

## Additional details:

The fixed conversion rates are listed below:

From | To | Rates | To Currency Name | Decimals |
---|---|---|---|---|

"EUR" | "ATS" | 13.7603 | Austrian schilling | 2 |

"EUR" | "BEF" | 40.3399 | Belgian franc | 0 |

"EUR" | "CYP" | 0.585274 | Cypriot pound | 2 |

"EUR" | "DEM" | 1.95583 | German mark | 2 |

"EUR" | "EEK" | 15.6466 | Estonian kroon | 2 |

"EUR" | "ESP" | 166.386 | Spanish peseta | 0 |

"EUR" | "FIM" | 5.94573 | Finnish markka | 2 |

"EUR" | "FRF" | 6.55957 | French franc | 2 |

"EUR" | "GRD" | 340.750 | Greek drachma | 2 |

"EUR" | "IEP" | 0.787564 | Irish pound | 2 |

"EUR" | "ITL" | 1,936.27 | Italian lira | 0 |

"EUR" | "LTL" | 3.45280 | Lithuanian litas | 2 |

"EUR" | "LUF" | 40.3399 | Luxembourg franc | 0 |

"EUR" | "LVL" | 0.702804 | Latvian lats | 2 |

"EUR" | "MTL" | 0.429300 | Maltese lira | 2 |

"EUR" | "NLG" | 2.20371 | Dutch guilder | 2 |

"EUR" | "PTE" | 200.482 | Portuguese escudo | 2 |

"EUR" | "SIT" | 239.640 | Slovenian tolar | 2 |

"EUR" | "SKK" | 30.1260 | Slovak koruna | 2 |

## Examples:

Formula | Description | Returns |
---|---|---|

=EUROCONVERT(100; "EUR"; "DEM") | Converts 100 euros into German marks, using the default number of two decimal places for the German mark. | 195.58 |

=EUROCONVERT(100; "ATS"; "EUR") | Converts 100 Austrian schillings into euros, using the default number of two decimal places for the euro. | 7.27 |

=EUROCONVERT(123.40; "ATS"; "BEF") | Converts 123.40 Austrian schillings into Belgian francs, using the default number of zero decimal places for the Belgian franc. | 362 |

=EUROCONVERT(123.40; "ATS"; "BEF"; TRUE()) | Converts 123.40 Austrian schillings into Belgian francs, using full precision. | 361.761274100129 |

=EUROCONVERT(1.5; "LTL"; "LVL"; 1) | Converts 1.5 Lithuanian litas into Luxembourg francs, using full precision. | 0.305319161260426 |

=EUROCONVERT(D1; D2; D3; D4; D5) where cell D1 contains the number 1.5, cell D2 contains the string "LTL", cell D3 contains the string "LVL", cell D4 contains the number 1, and cell D5 contains the number 4. | Converts 1.5 Lithuanian litas into Luxembourg francs, using full precision for the result but rounding the intermediate result of the triangular conversion to 4 places. Note that this change to the handling of the intermediate value gives a different end result compared to the previous example. | 0.3052980576 |

## Related LibreOffice functions:

## ODF standard:

## Related (or similar) Excel functions:

EUROCONVERT