Documentation/Calc Functions/CONVERT OOO

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 Eurozone, and vice versa. The conversion uses the fixed exchange rates at which the legacy currencies entered the euro.

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.


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

Related LibreOffice functions:
CONVERT

EUROCONVERT

ODF standard:
None

Equivalent Excel functions:
None