This function converts currency from a Euro member currency (including Euros) to another Euro member currency (including Euros).
Syntax
EUROCONVERT(currency,source,target,fullprecision,triangulation)
Arguments
This function has these arguments:
| Argument | Description |
|---|---|
| currency | Number to convert |
| source | ISO currency code for the number to convert (see table below) |
| target | ISO currency code for the result of the conversion (see table below) |
| fullprecision | [Optional] Logical value representing whether to display the value in full precision or not; if omitted, the value is not displayed in full precision |
| triangulation | [Optional] Integer greater than or equal to 3 that specifies the number of significant digits to be used for the intermediate Euro value when converting between two Euro member currencies |
If triangulation is omitted, the calculation does not round the intermediate Euro value. If it is included when converting from a Euro member currency to the Euro, the calculation finds the intermediate Euro value that could then be converted to a Euro member currency.
Remarks
This function does not convert all currencies; only those Euro member currencies listed in this table.
| Country/Region | ISO Currency Code |
|---|---|
| Belgium | BEF |
| Luxembourg | LUF |
| Germany | DEM |
| Spain | ESP |
| France | FRF |
| Ireland | IEP |
| Italy | ITL |
| Netherlands | NLG |
| Austria | ATS |
| Portugal | PTE |
| Finland | FIM |
| Euro member state | EUR |
ISO Currency Codes are from ISO 4217, the international standard describing three-letter codes to define the names of currencies. ISO is the nickname for the International Organization for Standardization.The first two letters of the code are the two-letter country codes (ISO 3166) and the third is usually the initial of the currency itself. So BEF is Belgium Franc.
Data Types
Accepts numeric and string data for most arguments; the fullprecision argument is a logical value. Returns numeric data.
Examples
EUROCONVERT(B5,"DEM","EUR")
EUROCONVERT(R5C2,"DEM","EUR", TRUE, 3)
Version Available
This function is available in product version 2.0 or later.