This function converts currency from a Euro member currency (including Euros) to another Euro member currency (including Euros).
EUROCONVERT(currency,source,target,fullprecision,triangulation)
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.
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.
Accepts numeric and string data for most arguments; the fullprecision argument is a logical value. Returns numeric data.
EUROCONVERT(B5,"DEM","EUR")
EUROCONVERT(R5C2,"DEM","EUR", TRUE, 3)