Documentation/Calc Functions/CONVERT OOO

From The Document Foundation Wiki
Jump to navigation Jump to search
Other languages:
English • ‎dansk



Function name:

CONVERT_OOO

Category:

Mathematical

Summary:

Converts to euros a currency value expressed in one of the legacy currencies of 19 member states of the European Union, and vice versa. The conversion uses the fixed exchange rates at which the legacy currencies entered the euro.

Tip.svg

Tip:
We recommend using the more flexible EUROCONVERT function for converting between these currencies. For converting between many different units of measurement, use the CONVERT function.


Syntax:

CONVERT_OOO(Value; Text1; Text2)

Returns:

Returns a real number which is the converted value expressed in the currency specified by the argument Text2.

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

Text1 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 possible case-sensitive strings – "ATS", "BEF", "CYP", "DEM", "EEK", "ESP", "EUR", "FIM", "FRF", "GRD", "IEP", "ITL", "LTL", "LUF", "LVL", "MTL", "NLG", "PTE", "SIT", and "SKK".

Text2 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 possible case-sensitive strings, as listed for Text1.

  • If Value is non-numeric, then CONVERT_OOO reports a #VALUE! error.
  • If either of Text1 or Text2 is not one of the expected strings specifying a valid currency, then CONVERT_OOO reports a #N/A error.
  • One, and only one, of Text1 and Text2 should specify the euro. Therefore, if neither or both are equal to "EUR", then CONVERT_OOO reports a #N/A error.

Additional details:

The following table lists the legacy, three-character currency codes recognised by CONVERT_OOO and the fixed conversion rate used for each currency.

Code Currency Rate
ATS Austrian schilling 13.7603
BEF Belgian franc 40.3399
CYP Cypriot pound 0.585274
DEM German mark 1.95583
EEK Estonian kroon 15.6466
ESP Spanish peseta 166.386
FIM Finnish markka 5.94573
FRF French franc 6.55957
GRD Greek drachma 340.750
IEP Irish pound 0.787564
ITL Italian lira 1936.27
LTL Lithuanian litas 3.45280
LUF Luxembourg franc 40.3399
LVL Latvian lats 0.702804
MTL Maltese lira 0.429300
NLG Dutch guilder 2.20371
PTE Portuguese escudo 200.482
SIT Slovenian tolar 239.640
SKK Slovak koruna 30.1260
  • For additional information about the history of the euro, see Wikipedia’s Euro page.
  • The currency codes and conversion rates are read from a configuration file named .../share/registry/main.xcd.

Examples:

Formula Description Returns
=CONVERT_OOO(100; "ATS"; "EUR") Here the function converts 100 Austrian schillings into euros. 7.26728341678597
=CONVERT_OOO(D1; D2; D3) where cells D1, D2 and D3 contain the number 100, the string "EUR", and the string "DEM" respectively. Here the function converts 100 euros to German marks. 195.583
=CONVERT_OOO(CONVERT_OOO(100; "FRF"; "EUR"); "EUR"; "ITL") Here 100 French francs are converted to euros, with the result then converted to Italian lire. Conversion between the national currencies is carried out using the process of triangulation via the euro. 29518.2458606281

Related LibreOffice functions:

CONVERT

EUROCONVERT

ODF standard:

None

Equivalent Excel functions:

None