Documentation/Calc Functions/EUROCONVERT

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

Related LibreOffice functions:
CONVERT_OOO

ODF standard:
Section 6.16.29, part 2

Equivalent Excel functions:
EUROCONVERT