Documentation/Calc Functions/EUROCONVERT/he

From The Document Foundation Wiki
Jump to navigation Jump to search
This page is a translated version of the page Documentation/Calc Functions/EUROCONVERT and the translation is 5% complete.
Other languages:
English • ‎Nederlands • ‎dansk • ‎español • ‎עברית



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 a real number that is the converted amount expressed in the target currency.

משתנים:

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).

פרטים נוספים:

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:

נוסחה תיאור מחזירה
=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:

CONVERT_OOO

ODF standard:

Section 6.16.29, part 2

Equivalent Excel functions:

EUROCONVERT