Documentation/Calc Functions/EUROCONVERT

From The Document Foundation Wiki
Jump to: navigation, search

Other languages:

Function name:

EUROCONVERT

Category:

Mathematical

Summary:

Converts currency values between the Euro and various legacy European national currencies, using fixed rates set by the European Commission.

Syntax:

EUROCONVERT(Value; From_currency; To_currency [; Full_precision [; Triangulation_precision]])

Returns:

Returns the a currency value in the form of To_currency for the input given in the form of From_currency.

Arguments:

Value is the amount of the currency to be converted.

From_currency and To_currency are the currency units to convert from and to respectively. These must be text and must be the official abbreviation for the currency (for example, "EUR"). The rates (shown per Euro) were set by the European Commission.

Full_precision (optional) If omitted or False, the result is rounded according to the decimals of the To_currency. If Full_precision is True, the result is not rounded.

Triangulation_precision (optional) If Triangulation_precision is given and >=3, the intermediate result of a triangular conversion (currency1,EUR,currency2) is rounded to that precision. If Triangulation_precision is omitted, the intermediate result is not rounded. Also if To_currency is "EUR", Triangulation_precision is used as if triangulation was needed and conversion from EUR to EUR was applied.

Additional details:

The fixed conversion rates are listed below:

From_Currency To_currency Rates Currency Decimals
"EUR" "ATS" 13.7603 Austrian Schilling 2
"EUR" "BEF" 40.3399 Belgian Franc 0
"EUR" "DEM" 1.95583 German Mark 2
"EUR" "ESP" 166.386 Spanish Peseta 0
"EUR" "FIM" 5.94573 Finnish Markka 2
"EUR" "FRF" 6.55957 French Franc 2
"EUR" "IEP" 0.787564 Irish Pound 2
"EUR" "ITL" 1936.27 Italian Lira 0
"EUR" "LUG" 40.3399 Luxembourg Franc 0
"EUR" "NLG" 2.20371 Dutch Guilder 2
"EUR" "PTE" 200.482 Portuguese Escudo 2
"EUR" "GRD" 340.750 Greek Drachma 2
"EUR" "SIT" 239.640 Slovenian Tolar 2
"EUR" "MTL" 0.429300 Maltese Lira 2
"EUR" "CYP" 0.585274 Cypriot Pound 2
"EUR" "SKK" 30.1260 Slovak Koruna 2
"EUR" "EEK" 15.6466 Estonian Kroon 2
"EUR" "LVL" 0.702804 Latvian Lats 2
"EUR" "LTL" 3.45280 Lithuanian Litas 2

Examples:

Formula Description Returns
=EUROCONVERT(100;"EUR";"DEM") converts 100 Euros into German Marks 195.58 (DEM)
=EUROCONVERT(100;"ATS";"EUR") converts 100 Austrian Schillings into Euros 7.27 (EUR)

Related LibreOffice functions:

CONVERT_OOO

ODF standard:

Section 6.16.29, part 2.

Equivalent Excel functions:

EUROCONVERT