Documentation/Calc Functions/EUROCONVERT/he
TDF LibreOffice Document Liberation Project בלוגים קהילתיים Weblate Nextcloud Redmine Ask LibreOffice תרומה
שם הפונקציה:
EUROCONVERT
קטגוריה:
מתמטית
תקציר:
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.
תחביר:
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 (שגיאה: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 (שגיאה: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 |
דוגמאות:
| נוסחה | תיאור | מחזירה |
|---|---|---|
| =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 |
פונקציות LibreOffice קשורות:
תקן ODF:
פונקציות Excel מקבילות (או דומות):
EUROCONVERT